CREATE TABLE ZDQ AS SELECT a.STRARDNO, b.* FROM GADATA0001.EMPLOYEE a,GADATA0001.SALARY b WHERE a.LNGEMPLOYEEID=b.LNGEMPLOYEEID
CREATE TABLE ZDQ as SELECT GADATA0001.EMPLOYEE.STRARDNO,GADATA0001.SALARY.* FROM GADATA0001.EMPLOYEE,GADATA0001.SALARY WHERE GADATA0001.EMPLOYEE.LNGEMPLOYEEID=GADATA0001.SALARY.LNGEMPLOYEEID
SELECT GADATA0001.EMPLOYEE.STRARDNO,GADATA0001.SALARY.*
*
ERROR 位于第 2 行:
ORA-00904: 无效列名
SELECT a.STRARDNO, b.*
FROM GADATA0001.EMPLOYEE a,GADATA0001.SALARY b WHERE a.LNGEMPLOYEEID=b.LNGEMPLOYEEID
SELECT GADATA0001.EMPLOYEE.STRARDNO,GADATA0001.SALARY.*
FROM GADATA0001.EMPLOYEE,GADATA0001.SALARY WHERE GADATA0001.EMPLOYEE.LNGEMPLOYEEID=GADATA0001.SALARY.LNGEMPLOYEEID