You need to extract data from the system your predecessor created. you discover tables have been created according to the third 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

b. join

Explanation:

Correct

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

Example in the image attached

Bad

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