Câu 30: 1D0-541: CIW v5 Database Design Specialist

Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?

1. A. SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;
2. B. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No; — đáp án hiện tại
3. C. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Employees.Sales_Rep_No = Customers.Sales_Rep_No;
4. D. SELECT * FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;