来自「JAVA下的SQL_System的建立」· 代码 · 共 7 行

SELECT orderID,customerID,employees.EmployeeID,firstName,LastName,orderDate
FROM orders join employees on orders.EmployeeID = employees.EmployeeID
上面的语句用来从表orders和employees中提取EmployeeID相同的记录。
用户也可以通过下面的语句实现同一种功能：
SELECT orderID,customerID,employees.EmployeeID,firstName,LastName,orderDate
FROM orders , employees where orders.EmployeeID=employees.EmployeeID