这条SQL语句错误,我找不到错误在哪里?请教。
这一条是正确的,
select A.*,B.Name ,C.BiddingNo
from T_ContractInfo A,T_Supplier B,T_InviteBid C
where A.SupplierID=B.SupplierID and A.BiddingID=C.BiddingID(+)
order by Name
在这条语句的基础上增加字段:SUM(D.UNITPRICE*D.NUMBERS) ConSum,
相应的在from 后面增加表D:T_MaterialList D,
在where后增加条件:and A.SupplierID=B.SupplierID
再增加一样组合语句:group by A.*,B.Name ,C.BiddingNo
增加后的语句如下:
(错误提示:ERROR 位于第 5 行:
ORA-01747: 无效的用户.表.列,表.列,或列规格)
select A.*,B.Name ,C.BiddingNo,SUM(D.UNITPRICE*D.NUMBERS) ConSum
from T_ContractInfo A,T_Supplier B,T_InviteBid C,T_MaterialList D
where A.ContractID=D.ContractID and A.BiddingID=C.BiddingID(+)
and A.SupplierID=B.SupplierID
group by A.*,B.Name ,C.BiddingNo
order by Name
首先声明表和列名称都是正确无误的。