select * from (SELECT * FROM T_CORP_LINKMAN) A , (SELECT CORPCD,CORPSHORTNAME From T_CORP_STATUS WHERE CORPSHORTNAME='112') B where A.CORPCD=B.CORPCD(+);--Oracle中給結果集取別名不能用as關鍵字,而且好像沒有inner join
SELECT A.*,B.CORPCD,B.CORPSHORTNAME FROM T_CORP_LINKMAN AS A INNER JOIN T_CORP_STATUS as B ON A.CORPCD=B.CORPCD WHERE B.CORPSHORTNAME='112' There is some difference between SQL and SyBase including Oracle
大家帮我想想还有什么地方可能有问题(除了SQL语句本身)
(SELECT * FROM T_CORP_LINKMAN) A ,
(SELECT CORPCD,CORPSHORTNAME From T_CORP_STATUS WHERE CORPSHORTNAME='112') B where A.CORPCD=B.CORPCD(+);--Oracle中給結果集取別名不能用as關鍵字,而且好像沒有inner join
竹之草兄给的SQL我可以用,谢谢,这分给你了,可是在SQL最后的(+)是什么意思?
WHERE B.CORPSHORTNAME='112'
There is some difference between SQL and SyBase including Oracle