大师：请问下面的SQL语句，如果数据源是SQL，没问题。如果改为access数据源，为何不对？S——————E_LECT t_Item.FNumber as xmid,t_Item.FName as xmname, Sum(t_Balance.FBeginBalance) AS je,t_Account.FNumber as kmid,t_Account.FName as kmname FROM (t_Item INNER JOIN t_ItemDetailV ON t_Item.FItemID=t_ItemDetailV.FItemID) INNER JOIN t_Balance ON t_ItemDetailV.FDetailID=t_Balance.FDetailID left join t_Account on t_Account.FAccountID = t_Balance.FAccountID WHERE (t_Balance.FYear=2014 and t_Balance.FPeriod=1 And t_Balance.FCurrencyID=0 And t_Balance.FDetailID>0) GROUP BY t_Balance.FAccountID,t_Item.FItemClassID,t_Item.FItemID,t_Item.FNumber,t_Item.FName,t_Account.FNumber,t_Account.FName
加好友 
发短信
Post By：2019/7/2 11:49:00 [只看该作者]
