This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请问，在SQL Server里，left join 可以用' *=', 请问在Oracle里面是什么？没用过Oracle. 谢谢。
-luoboyang(萝卜秧);
2004-2-27
(#1623002@0)
-
outer join? t1.c1(+)=t2.c1 没用过SQL Server :)
-cloud2001(卷云溶月*冰花飞扬*);
2004-2-27
(#1623024@0)
-
it should be t1.c1=t2.c1(+) , left join.in sql server 't1 left join t2 ..."equal to "t1.c1*=t2.c1" and 't1.c1=t2.c1(+)' in oracle.
-----------------"right join" ---------"=*" -----"t1.c1(+)=t2.c1"
-bluebluesky(bluebluesky);
2004-2-27
{169}
(#1623079@0)
-
wow, thanks!
-luoboyang(萝卜秧);
2004-2-27
(#1623099@0)
-
好像行。谢谢。：）
-luoboyang(萝卜秧);
2004-2-27
(#1623094@0)
-
在sql server 推荐用sql92标准,把left outer join写在from 子句中,oracle 中是否一样
-cathy618(明年);
2004-2-27
(#1623202@0)
-
应该一样，只不过我习惯了符号的用法。：）
-luoboyang(萝卜秧);
2004-2-27
(#1623251@0)
-
Avoid '*=', not because it is not ANSI 92 compliant, but also under certain circumstances, it would produce incorrect results.
Oracle 9i is ANSI 92 compliant. You can use 'left join' same as SQL Server.
-mit(mit);
2004-2-28
(#1624489@0)