SELECT cls.*, yplan.* from Mpt_CostItem cls INNER JOIN Mpt_YearPlan yplan ON cls.CostItem_ID = yplan.YearPlan_ItemID GROUP BY yplan.YearPlan_ItemID ORDER BY yplan.YearPlan_ID
上面的语运行肯定是通不过的如果改成这样 SQL code:
SELECT max(cls.字段), max(yplan.字段) from Mpt_CostItem cls INNER JOIN Mpt_YearPlan yplan ON cls.CostItem_ID = yplan.YearPlan_ItemID GROUP BY yplan.YearPlan_ItemID ORDER BY yplan.YearPlan_ID
