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
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