Marque a consulta que recupera o nome dos colaboradores e, caso exista, de seus depententes.

Question

Accepted Answer

SELECT e.Fname, 
        d.Dependent_name 
 FROM dependent d 
 RIGHT JOIN employee e ON e.Ssn = d.Essn 
 ORDER BY 1, 2;

Answer

SELECT e.Fname, 
        d.Dependent_name 
 FROM  employee e 
 NATURAL JOIN dependent d 
 ORDER BY 1, 2;

Answer

SELECT e.Fname, 
        d.Dependent_name 
 FROM dependent d 
 LEFT JOIN employee e ON e.Ssn = d.Essn 
 ORDER BY 1, 2;

Answer

SELECT e.Fname, 
        d.Dependent_name 
 FROM dependent d 
 JOIN employee e USING (e.Ssn = d.Essn) 
 ORDER BY 1, 2;

Answer

SELECT e.Fname, 
        d.Dependent_name 
 FROM employee e 
 INNER JOIN dependent d ON e.Ssn = d.Essn 
 ORDER BY 1, 2;

Crowdly