麻烦各位大哥大姐帮我看下这句SQL语句哪里错了,谢谢。
老是提示 “'>' 附近有语法错误。”SELECT dbo.PO_Pomain.dPODate, dbo.PO_Pomain.cPOID, dbo.Vendor.cVenCode,
dbo.Vendor.cVenName, dbo.Inventory.cInvName, dbo.PO_Podetails.iQuantity,
SUM(dbo.RdRecords.iQuantity), dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity),
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) >= 0 as 入库未完成 ,
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) < 0 as 入库已完成
FROM dbo.PO_Pomain,dbo.Vendor,dbo.Inventory,dbo.PO_Podetails,dbo.RdRecords
WHERE year(dbo.PO_Pomain.dPODate ) ='2011' and month(dbo.PO_Pomain.dPODate ) = '5'
and dbo.Vendor.cVenCode LIKE '2%' AND dbo.Inventory.cInvCode = dbo.PO_Podetails.cInvCode
AND dbo.PO_Pomain.POID = dbo.PO_Podetails.POID AND dbo.Vendor.cVenCode = dbo.PO_Pomain.cVenCode
AND dbo.RdRecords.iPOsID = dbo.PO_Podetails.ID
GROUP BY dbo.PO_Pomain.dPODate,dbo.PO_Pomain.cPOID,dbo.Vendor.cVenCode,dbo.Vendor.cVenName,
dbo.Inventory.cInvName,.dbo.PO_Podetails.iQuantity ORDER BY dbo.PO_Pomain.cPOID,{bo.Inventory.cInvName
老是提示 “'>' 附近有语法错误。”SELECT dbo.PO_Pomain.dPODate, dbo.PO_Pomain.cPOID, dbo.Vendor.cVenCode,
dbo.Vendor.cVenName, dbo.Inventory.cInvName, dbo.PO_Podetails.iQuantity,
SUM(dbo.RdRecords.iQuantity), dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity),
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) >= 0 as 入库未完成 ,
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) < 0 as 入库已完成
FROM dbo.PO_Pomain,dbo.Vendor,dbo.Inventory,dbo.PO_Podetails,dbo.RdRecords
WHERE year(dbo.PO_Pomain.dPODate ) ='2011' and month(dbo.PO_Pomain.dPODate ) = '5'
and dbo.Vendor.cVenCode LIKE '2%' AND dbo.Inventory.cInvCode = dbo.PO_Podetails.cInvCode
AND dbo.PO_Pomain.POID = dbo.PO_Podetails.POID AND dbo.Vendor.cVenCode = dbo.PO_Pomain.cVenCode
AND dbo.RdRecords.iPOsID = dbo.PO_Podetails.ID
GROUP BY dbo.PO_Pomain.dPODate,dbo.PO_Pomain.cPOID,dbo.Vendor.cVenCode,dbo.Vendor.cVenName,
dbo.Inventory.cInvName,.dbo.PO_Podetails.iQuantity ORDER BY dbo.PO_Pomain.cPOID,{bo.Inventory.cInvName
解决方案 »
- 如何执行sql文件
- t-sql 语句 (急急等考试)
- ??? 现有两表:Tongji表、T1表,两表都为n行n列,请问如何更新T1表 ???
- 求助:暂时关闭自动编号功能的SQL怎么写了?
- 请高人帮忙在windows7配置SQL2005本地报表服务器和报表管理器.
- 如何获得今天的日期?????
- windows Server 2003 Enterprise Edition 版上装SQL SERVER2000不能创建库,有人遇到这个问题么?
- 数量作“弊功”能怎么实现?
- 如何恢复不同SortID的数据库
- sql2008 insert插入数据时,id不能自增,这是为什么
- SQL语句
- 新手高分求解!关于安装数据库的问题?
dbo.Vendor.cVenName, dbo.Inventory.cInvName, dbo.PO_Podetails.iQuantity,
SUM(dbo.RdRecords.iQuantity), dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity),
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) as 入库未完成 ,
(dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) as 入库已完成
FROM dbo.PO_Pomain,dbo.Vendor,dbo.Inventory,dbo.PO_Podetails,dbo.RdRecords
WHERE year(dbo.PO_Pomain.dPODate ) ='2011' and month(dbo.PO_Pomain.dPODate ) = '5'
and dbo.Vendor.cVenCode LIKE '2%' AND dbo.Inventory.cInvCode = dbo.PO_Podetails.cInvCode
AND dbo.PO_Pomain.POID = dbo.PO_Podetails.POID AND dbo.Vendor.cVenCode = dbo.PO_Pomain.cVenCode
AND dbo.RdRecords.iPOsID = dbo.PO_Podetails.ID
GROUP BY dbo.PO_Pomain.dPODate,dbo.PO_Pomain.cPOID,dbo.Vendor.cVenCode,dbo.Vendor.cVenName,
dbo.Inventory.cInvName,PO_Podetails.iQuantity ORDER BY dbo.PO_Pomain.cPOID,Inventory.cInvName
SELECT dbo.PO_Pomain.dPODate, dbo.PO_Pomain.cPOID, dbo.Vendor.cVenCode,
dbo.Vendor.cVenName, dbo.Inventory.cInvName, dbo.PO_Podetails.iQuantity,
SUM(dbo.RdRecords.iQuantity), dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity), CASE WHEN (dbo.PO_Podetails.iQuantity - SUM(dbo.RdRecords.iQuantity)) >= 0 THEN '入库未完成' ELSE '入库已完成' end FROM dbo.PO_Pomain,dbo.Vendor,dbo.Inventory,dbo.PO_Podetails,dbo.RdRecords
WHERE year(dbo.PO_Pomain.dPODate ) ='2011' and month(dbo.PO_Pomain.dPODate ) = '5'
and dbo.Vendor.cVenCode LIKE '2%' AND dbo.Inventory.cInvCode = dbo.PO_Podetails.cInvCode
AND dbo.PO_Pomain.POID = dbo.PO_Podetails.POID AND dbo.Vendor.cVenCode = dbo.PO_Pomain.cVenCode
AND dbo.RdRecords.iPOsID = dbo.PO_Podetails.ID
GROUP BY dbo.PO_Pomain.dPODate,dbo.PO_Pomain.cPOID,dbo.Vendor.cVenCode,dbo.Vendor.cVenName,
dbo.Inventory.cInvName,PO_Podetails.iQuantity ORDER BY dbo.PO_Pomain.cPOID,Inventory.cInvName
这是想做什么