Join not Supported

  • Thread starter vinodh ramadurai
  • Start date
V

vinodh ramadurai

The below query is not working. i am getting error like 'join not supported'

SELECT Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam,
Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk,
Tbl_Inventory.ExcShortage,
sum(Tbl_PurchaseSub.NUnit) AS SumOfNUnit, sum(Tbl_SalesSub.Qty) AS SumOfQty
FROM Tbl_SalesMain RIGHT JOIN (Tbl_PurchaseMain
RIGHT JOIN (((Tbl_Inventory
inner JOIN Tbl_ProductGroupMaster ON Tbl_Inventory.PROID =
Tbl_ProductGroupMaster.PROID)
inner JOIN Tbl_PurchaseSub ON Tbl_ProductGroupMaster.PROID =
Tbl_PurchaseSub.PROID)
inner JOIN Tbl_SalesSub ON Tbl_ProductGroupMaster.PROID =
Tbl_SalesSub.PROID) ON (Tbl_PurchaseMain.IDate = Tbl_Inventory.CrDate) AND
(Tbl_PurchaseMain.GID = Tbl_PurchaseSub.GID)) ON (Tbl_SalesMain.IDate =
Tbl_Inventory.CrDate) AND (Tbl_SalesMain.SAID = Tbl_SalesSub.SAID) group by
Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam,
Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk,
Tbl_Inventory.ExcShortage
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorrect sum in MS Access query 1
Top 3 per group 3
perform INNER JOIN on query results 2
specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
SQL SYNTAX ERROR HELP !!!!!!!!!!!!!!!!!!!!!!!!!!!!........................ 2
Sum means empty query? 5
Nested JOIN clauses - order of precedence (Access 2007) 2
Null Values 5

Top