sql="SELECT PU_Order.Date, PU_OrdDetail.BillID, PU_Vendor.ShortName As VendorName, FD_Article.ArtCode, FD_Article.Name As ArtName, PU_OrdDetail.MeasID, PU_OrdDetail.Qty, PU_OrdDetail.Price, MAX(i.Price) AS MaxInPrice, MIN(i.Price) AS MinInPrice, PU_OrdDetail.Memo "
sql=sql&"FROM (SELECT OrderID, OrderSortID, Price FROM PU_InBill INNER JOIN PU_InDetail ON PU_InBill.BillID = PU_InDetail.BillID WHERE NOT Execer IS NULL) AS i "
sql=sql&"INNER JOIN PU_Order "
sql=sql&"INNER JOIN PU_OrdDetail ON PU_Order.BillID = PU_OrdDetail.BillID "
sql=sql&"INNER JOIN FD_Article ON PU_OrdDetail.ArtID = FD_Article.ID "
sql=sql&"INNER JOIN PU_Vendor ON PU_Order.VendorID = PU_Vendor.ID "
sql=sql&"ON i.OrderID = PU_OrdDetail.BillID And i.OrderSortID = PU_OrdDetail.SortID "
sql=sql&"Where Not PU_Order.Checker Is Null And PU_Order.Date >= '2008-06-01' And PU_Order.Date < '2008-07-01' And PU_OrdDetail.InQty > 0 "
sql=sql&"GROUP BY PU_Order.Date, PU_OrdDetail.BillID, PU_Vendor.ShortName, FD_Article.ArtCode, FD_Article.Name, PU_OrdDetail.MeasID, PU_OrdDetail.Qty, PU_OrdDetail.Price, PU_OrdDetail.Memo "
这段语句中的“sql=sql&"ON i.OrderID = PU_OrdDetail.BillID And i.OrderSortID = PU_OrdDetail.SortID "”中是不是缺少了JOIN呢?
sql=sql&"FROM (SELECT OrderID, OrderSortID, Price FROM PU_InBill INNER JOIN PU_InDetail ON PU_InBill.BillID = PU_InDetail.BillID WHERE NOT Execer IS NULL) AS i "
sql=sql&"INNER JOIN PU_Order "
sql=sql&"INNER JOIN PU_OrdDetail ON PU_Order.BillID = PU_OrdDetail.BillID "
sql=sql&"INNER JOIN FD_Article ON PU_OrdDetail.ArtID = FD_Article.ID "
sql=sql&"INNER JOIN PU_Vendor ON PU_Order.VendorID = PU_Vendor.ID "
sql=sql&"ON i.OrderID = PU_OrdDetail.BillID And i.OrderSortID = PU_OrdDetail.SortID "
sql=sql&"Where Not PU_Order.Checker Is Null And PU_Order.Date >= '2008-06-01' And PU_Order.Date < '2008-07-01' And PU_OrdDetail.InQty > 0 "
sql=sql&"GROUP BY PU_Order.Date, PU_OrdDetail.BillID, PU_Vendor.ShortName, FD_Article.ArtCode, FD_Article.Name, PU_OrdDetail.MeasID, PU_OrdDetail.Qty, PU_OrdDetail.Price, PU_OrdDetail.Memo "
这段语句中的“sql=sql&"ON i.OrderID = PU_OrdDetail.BillID And i.OrderSortID = PU_OrdDetail.SortID "”中是不是缺少了JOIN呢?
解决方案 »
- 類型轉換的問題
- 我的数据库原来的运行环境是sql-server的,现在改成连接MSDE,我应该怎么设置才能使程序运行?
- 从excel中往sql2005里导入数据出错!!!求高手救援啊!!!
- 存储过程里面调用存储过程,但是需要传递 output 参数给下一个存储过程
- erwin关系图 帮我看看这样正确不
- WIN7下安装SQL2005开发版SQL server setup停止工作,错误如下
- sql server2005全文检索效能很差?
- 急啊 请各位高手帮忙啊
- 菜鸟问题:关于临时表!
- 请教一个存储过程~~~请大家帮帮手~~
- 急急!!哪里错了????
- 看了很多IT的精英们的题问感角非常的深,希望这个小小的建议能够帮助大家更好的在IE行业当中做佼佼者
--注意空格,try:
sql="SELECT PU_Order.Date, PU_OrdDetail.BillID, PU_Vendor.ShortName As VendorName, FD_Article.ArtCode, FD_Article.Name As ArtName, PU_OrdDetail.MeasID, PU_OrdDetail.Qty, PU_OrdDetail.Price, MAX(i.Price) AS MaxInPrice, MIN(i.Price) AS MinInPrice, PU_OrdDetail.Memo "
sql=sql&" FROM (SELECT OrderID, OrderSortID, Price FROM PU_InBill INNER JOIN PU_InDetail ON PU_InBill.BillID = PU_InDetail.BillID WHERE NOT Execer IS NULL) AS i "
sql=sql&" INNER JOIN PU_Order "
sql=sql&" INNER JOIN PU_OrdDetail ON PU_Order.BillID = PU_OrdDetail.BillID "
sql=sql&" INNER JOIN FD_Article ON PU_OrdDetail.ArtID = FD_Article.ID "
sql=sql&" INNER JOIN PU_Vendor ON PU_Order.VendorID = PU_Vendor.ID "
sql=sql&" ON i.OrderID = PU_OrdDetail.BillID And i.OrderSortID = PU_OrdDetail.SortID "
sql=sql&" Where Not PU_Order.Checker Is Null And PU_Order.Date >= '2008-06-01' And PU_Order.Date < '2008-07-01' And PU_OrdDetail.InQty > 0 "
sql=sql&" GROUP BY PU_Order.Date, PU_OrdDetail.BillID, PU_Vendor.ShortName, FD_Article.ArtCode, FD_Article.Name, PU_OrdDetail.MeasID, PU_OrdDetail.Qty, PU_OrdDetail.Price, PU_OrdDetail.Memo "
另外INNER JOIN PU_Order 中没有连接条件