打个比方 Oracle中这么写的语句
select a.x,
b.y,
c.z
from a,
b,
c
where a.x=b.x(+)
and a.y=b.y(+)
and a.z=c.z(+)
在mysql中如何写?
select d.x,
d.y,
c.z
from (a right join b on a.x=b.x and a.y=b.y) d right join c on d.z=c.z这样可以吗?
select a.x,
b.y,
c.z
from a,
b,
c
where a.x=b.x(+)
and a.y=b.y(+)
and a.z=c.z(+)
在mysql中如何写?
select d.x,
d.y,
c.z
from (a right join b on a.x=b.x and a.y=b.y) d right join c on d.z=c.z这样可以吗?
right join b on a.x=b.x and a.y=b.y
right join c on a.z=c.z
from a right join b using(x,y)
right join c using(z)