PrepAway - Latest Free Exam Questions & Answers

Query: SELECT * FROM TABLE T1 INNER JOIN T2 ON T1.ID = T2.ID is equivalent to?

Query: SELECT * FROM TABLE T1 INNER JOIN T2 ON T1.ID = T2.ID is equivalent to?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT * FROM TABLE T1,TABLE T2 WHERE T1.ID = T2.ID

B.
SELECT * FROM TABLE T1 Left outer join TABLE T2 WHERE T1.ID = T2.ID

C.
SELECT * FROM TABLE T1 full join TABLE T2 WHERE T1.ID = T2.ID

D.
SELECT * FROM TABLE T2 Right outer join TABLE T1 WHERE T1.ID = T2.ID

Explanation:


Leave a Reply