请问这句left join应该怎么写？

[kucao]

我有三个数据表[A][B][C]，他们之间的关系我分别用两段语句来描述

[A]和[B]的关系：
select a.id,b.mc from [A] as a left join
(select id,aid,mc from [B] where 查询条件) as b
on a.id=b.aid
where 查询条件
这条语句这样写没问题。

[A]和[C]的关系：
select a.id,c.lx from [A] as a, [C] as c where a.cid=c.id and 查询条件
这条语句这样写也没问题。

但是我要三个表联合后就有问题了，要[A]和[C]联合后然后left join [B]，我是这样写的

select a.id,b.mc,c.lx from [A] as a, [C] as c left join
(select id,aid,mc from [B] where 查询条件) as b
on a.id=b.aid
where a.cid=c.id and 查询条件

这样写提示
Microsoft OLE DB Provider for SQL Server '80040e14'
无法绑定由多个部分组成的标识符 "a.id"。

请问这句语句我该如何来写？非常感谢。

[AcHerat]

select a.id,b.mc,c.lx 
from [A] as a join [C] as c on a.cid = c.id
   left join
(select id,aid,mc from [B] where 查询条件) as b  
 on a.id=b.aid  
where 查询条件

[开着拖拉机泡妞]

你那样写当然不行了，楼上的可以，你试试

[kucao]

非常感谢，测试了，好用！结贴！