试试这个:[您没有加入客户和员工表]
SELECT
EMPLOYEE.EMPID,
FIRST, LAST,
LOCATION.LOCATIONID
FROM CUSTOMER, EMPLOYEE, LOCATION
WHERE
CUSTOMER.CUSTID = EMPLOYEE.CUSTID AND
EMPLOYEE.LOCATIONID = LOCATION.LOCATIONID AND
AND EMPLOYEE.EMPID = '111111';
在Oracle中使用SQL从3个表中选择数据
试试这个:[您没有加入客户和员工表]
SELECT
EMPLOYEE.EMPID,
FIRST, LAST,
LOCATION.LOCATIONID
FROM CUSTOMER, EMPLOYEE, LOCATION
WHERE
CUSTOMER.CUSTID = EMPLOYEE.CUSTID AND
EMPLOYEE.LOCATIONID = LOCATION.LOCATIONID AND
AND EMPLOYEE.EMPID = '111111';