You need to retrieve data from two related database tables based on a column that exists in both
tables.
Which command should you use in a query?
A.
INTERSECT
B.
UNION
C.
JOIN
D.
TRUNCATE
Which command should you use in a query?
You need to retrieve data from two related database tables based on a column that exists in both
tables.
Which command should you use in a query?
C. Join
C join is correct answer accroding to given question
I would also say join, it is not asking for the data to be displayed from both tables, just that the tables have field/key that exists in both.