3个表where 语句接join

[Jenf_Mu]

select * from a, b
where a.id = b.id
left join c
on (剩下的a的id) = c.id

我知道临时表的写法，如果不用临时表的话，怎么办？

临时表的写法是

select a.id id1, b.id id2 into #t from a, b
where a.id = b.id

select * from #t a
left join c
on a.id = c.id

[dawugui]

最好给出完整的表结构,测试数据,计算方法和正确结果.否则耽搁的是你宝贵的时间。
如果有多表,表之间如何关联?

发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281

[快溜]

select * from a 
inner join b on a.id = b.id
left join c on a.id = c.id

[dawugui]

select a.* from a
left join b on a.id = b.id
left join c on a.id = c.id

select a.* from a , b where a.id = b.id
union all
select a.* from a , c where a.id = c.id

[--小F--]

select a.* from a  
left join b on a.id = b.id
left join c on a.id = c.id

[叶子]

select * from a 
left join b on a.id = b.id
left join c on a.id = c.id