ORACLE :
select a.a1,a.a2,b.b1,b.b2 from ee a , ff b where a.a1=b.b1(+);
这个是ORACLE下写的,如何在Sysbase中写此语句?
------解决方案--------------------------------------------------------
- SQL code
select a.a1,a.a2,b.b1,b.b2 from ee a , ff b where a.a1=b.b1*;
------解决方案--------------------------------------------------------
a.a1=b.b1(+):是右连接?
select a.a1,a.a2,b.b1,b.b2 from ee a right join ff b on a.a1=b.b1
------解决方案--------------------------------------------------------
- SQL code
select a.a1,a.a2,b.b1,b.b2 from ee a , ff b where a.a1*=b.b1
------解决方案--------------------------------------------------------
换成left join 吧,比较通用一些。
select a.a1,a.a2,b.b1,b.b2 from ee a left join ff b on a.a1=b.b1;