Select ta.AID, ta.AName, tc.Cnt
From (ATB as ta
left join (Select CID, Count(SID) as Cnt from CTB group by CID) as tc
on ta.CID = tc.CID)
...全文
18512打赏收藏
access在join时支持子查询吗?
这句SQLSERVER的查询语句应该怎样转换为ACCESS中的查询语句 Select ta.AID, ta.AName, tc.Cnt From (ATB as ta left join (Select CID, Count(SID) as Cnt from CTB group by CID) as tc on ta.CID = tc.CID)