Selecione todas as consultas que sejam equivalentes:
SELECT *
FROM
Customer c, Employee e1, Employee e2
WHERE
c.SupportRepId = e1.EmployeeId
AND e1.ReportsTo = = e2.EmployeeId;

Question

Selecione todas as consultas que sejam equivalentes: 
 SELECT   *  
 FROM  
    Customer c, Employee e1, Employee e2
 WHERE  
    c.SupportRepId = e1.EmployeeId
 AND  e1.ReportsTo = = e2.EmployeeId;

Answer

SELECT   *   
 FROM  Customer c, Employee e1, Employee e2 
 WHERE  c.SupportRepId = e2.EmployeeId 
 AND  e1.ReportsTo == e2.EmployeeId;

Answer

SELECT   * 
 FROM  Customer  AS  c 
 INNER JOIN  Employee  AS  e1  ON  c.SupportRepId  =  e1.EmployeeId 
 INNER JOIN  Employee  AS  e2  ON  e1.ReportsTo  =  c.SupportRepId;

Answer

SELECT   *   
 FROM  Customer c 
 INNER JOIN  Employee e1  ON  c.SupportRepId  =  e1.EmployeeId 
 INNER JOIN  Employee e2  ON  e1.ReportsTo  =  e2.EmployeeId;

Answer

SELECT   * 
 FROM  Customer  AS  c 
 INNER JOIN  Employee  AS  e1  ON  c.SupportRepId  =  e1.EmployeeId 
 INNER JOIN  Employee  AS  e2  ON  e1.ReportsTo  =  e2.EmployeeId;

Answer

SELECT   * 
 FROM  Customer  AS  c 
 INNER JOIN  Employee  AS  e1  ON  c.SupportRepId  =  e1.EmployeeId 
 INNER JOIN  Employee  AS  e2  ON  e1.ReportsTo  =  c.SupportRepId;

Crowdly

Selecione todas as consultas que sejam equivalentes: SELECT * FROM ...

Want instant access to all verified answers on moodle.fei.edu.br?