我试图从表中获取所有信息a
,但得到错误:
ORA-00904:"A":无效的标识符.
这是我的查询:
SELECT a FROM FORMS a, APPLICATIONS b WHERE b.APPLICATION_ID = a.APPLICATION_ID AND a.APPLICATION_ID = 14980
怎么了?
SELECT a.* FROM FORMS a, APPLICATIONS b WHERE b.APPLICATION_ID = a.APPLICATION_ID AND a.APPLICATION_ID = 14980;
最好使用新语法:
SELECT a.* FROM FORMS a JOIN APPLICATIONS b ON b.APPLICATION_ID = a.APPLICATION_ID WHERE a.APPLICATION_ID = 14980;