查询问题

[jamzh]

查询表a中的字段col1，col2与表b中的字段col3
表a（id）与表b（name）同过表c（id，name）联系
要求能将a，b合并成一个表
如何查询
并且将为空的数据设置为0

[welyngj]

select isnull(d.col1,0)col1 ,isnull(d.col2,0) col2, isnull(b.col3,0)col3 into temp1 from b left join
(select col1,col2,c.name,c.id from a , c where a.id=c.id )as d
on b.name=d.name

[welyngj]

select isnull(d.col1,0)col1 ,isnull(d.col2,0) col2, isnull(b.col3,0)col3 into temp1 from b left join
(select col1,col2,c.name,c.id from a , c where a.id=c.id )as d
on b.name=d.name
然后select * from temp1

[txlicenhe]

是这样吗？
Select IsNull(a.col1,0),IsNull(a.col2,0),IsNull(b.col3,0)
from c
join a on a.id = c.id
join b on b.name = c.name