不显示删除回复显示所有回复显示星级回复显示得分回复 十分紧急的问题，紧急求助。oracle9i的left join有状况[

[happyct]

问题地址：http://topic.csdn.net/u/20090724/23/1c4bdbea-9b1c-4564-91a5-324e24757ce1.html

[hebo2005]

select a.id,b.orderid,c.amount,d.sales 
from table1 a ,table2 b ,table3 c ,table4 d 
  where a.id=b.id(+)
and  a.id=c.id(+) 
and  a.id=d.id(+); 

[inthirties]

[Quote=引用 1 楼 hebo2005 的回复:]
SQL codeselect a.id,b.orderid,c.amount,d.salesfrom table1 a ,table2 b ,table3 c ,table4 dwhere a.id=b.id(+)and a.id=c.id(+)and a.id=d.id(+);
[/Quote]

这样的写法和left join是一致的吧