You need to extract data from the system your predecessor created. you discover tables have been created according to the third

Question

3 years ago

7

normal form. you find the needed data in three different tables. what SQL syntax allows you to garner this data?
a. union
b. join
c. Select
d. Having

1 answer:

MissTica · Answer 1 · 2022-05-14T16:19:48+03:00

Answer:

b. join

Explanation:

Correct answer:

Join: It allow join(paste) two tables by one or more commun columns

Example in the image attached

Bad answer:

Union: it only allow paste two tables with the same structure

select: it only allow get information from 1 table if not use join

having: it only allow get filtered information with a condition