JAVA下的SQL_System的建立

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