试试这个没有测试
SELECT SUM(UnitPrice*Amount)
2 FROM "5000YEARS"."ContactItems" ,"5000YEARS"."BuySales" ,"5000YEARS"."Parts" where
WHERE BuySales.BuySale='S'
AND ContactID=BuySales.ID
AND "ContactItems".Parts="Parts".ID
GROUP BY "ContactItems".Parts;
SELECT SUM(UnitPrice*Amount)
2 FROM "5000YEARS"."ContactItems" ,"5000YEARS"."BuySales" ,"5000YEARS"."Parts" where
WHERE BuySales.BuySale='S'
AND ContactID=BuySales.ID
AND "ContactItems".Parts="Parts".ID
GROUP BY "ContactItems".Parts;
SELECT SUM(a.UnitPrice*a.Amount)
FROM "5000YEARS"."ContactItems" a ,"5000YEARS"."BuySales" b ,"5000YEARS"."Parts" c where
WHERE b.BuySale='S'
AND a.ContactID=b.ID
AND aParts=c.ID
GROUP BY a.Parts;
WHERE b.BuySale='S' AND a.CONTACTID=b.ID AND a.Parts=c.ID GROUP BY c.id;
w_tsinghua() 的告诉有点毛病
SQL> SELECT SUM(a.UnitPrice*a.Amount)
2 FROM "5000YEARS"."ContactItems" a ,"5000YEARS"."BuySales" b ,"5000YEARS"."Parts" c where
3 WHERE b.BuySale='S'
4 AND a.ContactID=b.ID
5 AND aParts=c.ID
6 GROUP BY a.Parts;
WHERE b.BuySale='S'
*
ERROR 位于第3行
ORA-00936: 缺少表达式
两位大侠能告诉我我错误所在吗!太谢谢了
的回复中缺一个.(点)
在后面的尝试中.已经加上了但是还是提示第3行缺少表达式
FROM ContactItems ci,BuySales bs,Parts p
WHERE bs.BuySale='S'
AND ci.ContactID=bs.ID
AND ci.Parts=p.ID
GROUP BY ci.Parts;
SELECT SUM(UnitPrice*Amount)
FROM "5000YEARS"."ContactItems" ,"5000YEARS"."BuySales","5000YEARS"."Parts"
WHERE "BuySales".BuySale='S'
AND ContactID="BuySales".ID
AND "ContactItems".Parts="Parts".ID
GROUP BY "ContactItems".Parts;