34,593
社区成员
发帖
与我相关
我的任务
分享left join多表关联
本人新人+菜鸟~~现在遇到个问题,望大虾们指教指教
table a,b,c
a: b: c:
id s1 id s2 id s3
------ -------- --------
1 d 1 e 1 8
2 r 2 q
3 g
select a.id,a.s1,is(b.s2,0)s2,isnull(c.s3,0)s3
from _________________________________________
想用id关联来把a,b,c的记录都显示,null的用0.....
table a,b,c
a: b: c:
id s1 id s2 id s3
------ -------- --------
1 d 1 e 1 8
2 r 2 q
3 g
select a.id,a.s1,is(b.s2,0)s2,isnull(c.s3,0)s3
from _________________________________________
想用id关联来把a,b,c的记录都显示,null的用0.....
...全文
请发表友善的回复…
发表回复
Grave_rain 2009-02-09
- 打赏
- 举报
没弄懂
anotheremail 2009-02-08
- 打赏
- 举报
select a.id,isnull(a.s1,0) as s1,isnull(b.s2,0) as s2,isnull(c.s3,0) as s3
from a full join b on a.id=b.id full join c on b.id=c.id
from a full join b on a.id=b.id full join c on b.id=c.id
