那多个表呢?还有
select * from tba a left join tbb b on a.id=b.id还有还一个tbc 呢?select * form
(select * from tba a left join tbb b on a.id=b.id) a left join tbc c on a.id=b.id一定要这么写吗?有没有更简单的办法呢?
谢谢!
select * from tba a left join tbb b on a.id=b.id还有还一个tbc 呢?select * form
(select * from tba a left join tbb b on a.id=b.id) a left join tbc c on a.id=b.id一定要这么写吗?有没有更简单的办法呢?
谢谢!
left join b
on a.id=b.id
left join c
on b.id=c.id
left join ...
on ..
left join z
on z.id=y.idon 里面是哪个id=哪个id这看你具体要求了.
如果从 a左连b,c那么条件都是 a.id=b.id, a.id=c.id
inner join B
on A.ID=B.ID
inner join C
on A.ID=C.IDleft join ,只将inner join 换成left join ,right join ,full join