Which query will find rows in a table that have no counterpart in another table?
A. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
B. SELECT left_tbl.*
FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.id
WHERE right_tbl.id IS NULL;
C. SELECT t1.name, t2.name2
FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
D. SELECT t1.name, t2.name2
FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
|
Download Printable PDF. VALID exam to help you PASS. |
 |