请教高手 select a.id,count1=isnull(b.count1,0),count2=isnull(c.count2,0) from tb1 a left join tb2 bon a.id=b.idleft join tb3 con a.id=c.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.id,count1=isnull(b.count1,0),count2=isnull(c.count2,0) from ta aleft join tb b on a.id=b.idleft join tc c on a.id=c.id select a.id, count1=isnull(b.count1,0), count2=isnull(c.count2,0) from ta a left join tb b on a.id=b.id left join tc c on a.id=c.id select a.id, count1=isnull(b.count1,0), count2=isnull(c.count2,0) from ta a left join tb b on a.id=b.id left join tc c on a.id=c.id select a.id,count1=isnull(b.count1,0),count2=isnull(c.count2,0) from 表1 a left join 表2 b on a.id=b.id left join 表3 c on a.id=c.id select a.id,count1=isnull(b.count1,0),count2=isnull(c.count2,0) from 表1 a left join 表2 b on a.id=b.id left join 表3 c on a.id=c.id 好象left join 只能用于两张表啊? 请教一存储过程如何写@ count的用法。。。新人求指导。。谢谢大家。。 如何给SQL SERVER 2000 备份?!~` 求sql 还原数据库报错 我想调试sqlserver2005中的存储过程? 数据库的表该用什么命名 缓冲问题 请教各位大虾一个问题! 请教:如何编程实现SQL Server自动将某dbf文件读进tables里,又如何生成dbf文件? 一个SQL语句 一个令我头疼的Sql语句,请各位大人帮忙了,小弟多谢了!
from ta a
left join tb b on a.id=b.id
left join tc c on a.id=c.id
a.id,
count1=isnull(b.count1,0),
count2=isnull(c.count2,0)
from ta a
left join tb b
on a.id=b.id
left join tc c
on a.id=c.id
a.id,
count1=isnull(b.count1,0),
count2=isnull(c.count2,0)
from ta a
left join tb b
on a.id=b.id
left join tc c
on a.id=c.id
left join 表2 b on a.id=b.id
left join 表3 c on a.id=c.id
left join 表2 b on a.id=b.id
left join 表3 c on a.id=c.id