Search results

  1. V

    Syntax error in left join

    The below query is giving syntax error. SELECT Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk, Tbl_Inventory.ExcShortage FROM (Tbl_Inventory LEFT OUTER JOIN Tbl_PurchaseMain ON (Tbl_Inventory.CrDate = Tbl_PurchaseMain.idate)) LEFT OUTER JOIN Tbl_SalesMain ON...
  2. V

    How to get the missing purchase record

    I am getting error . Can you please rewrite the query.How to use left join? SELECT Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam, Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk, Tbl_Inventory.ExcShortage, purchase.SumOfNUnit, sales.SumOfQty FROM...
  3. V

    How to get the missing purchase record

    SELECT Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam, Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk, Tbl_Inventory.ExcShortage, purchase.SumOfNUnit, sales.SumOfQty FROM Tbl_ProductGroupMaster, Tbl_Inventory, [SELECT Tbl_PurchaseMain.idate as p_idate...
Back
Top Bottom