join left on多张表_left join on 多表同表不同条件

不好意思！能否按照我的代码详细给点提示咯！我按照你写的第一种方法

sql="select * from("

sql=sql&" select a.ID as DID,"

sql=sql&" IsNull(sum(b.Signing_AmountIN),0) as q1a,"

sql=sql&" from KL_Depart as a"

sql=sql&" left join KL_Signing b"

sql=sql&" on b.DepartID = a.ID"

sql=sql&" and b.Signing_Stage = 3 and b.UnitID = "&KL_UnitID&" and b.Signing_UseDate between '"&CDate(BDate)&"' and '"&CDate(BDate2)&"'"

sql=sql&" where a.UnitID ="&KL_UnitID&" and a.ISWriteOFF = 0"

sql=sql&" ) as aa inner join ("

sql=sql&" select a.ID as DID,"

sql=sql&" IsNull(sum(b.Signing_AmountIN),0) as q2a"

sql=sql&"