view

SELECT     dbo.PURCHASESORDERBOM.PURBOMID, dbo.PURCHASESORDERBOM.DATE, dbo.ITEM.ITEMNAME, dbo.PURCHASESORDER.CINVNO AS cno,
                      dbo.PURCHASESORDERBOM.CQTY, dbo.PURCHASESORDERBOM.CRATE, dbo.PURCHASESORDERBOM.VALUE AS amt,
                      dbo.PURCHASESORDERBOM.VATAMT, dbo.PURCHASESORDERBOM.DIS, dbo.PURCHASESORDERBOM.DISAMT, dbo.PURCHASESORDERBOM.TOTAL,
                      dbo.PURCHASESORDERBOM.Complit, dbo.PURCHASESORDERBOM.Brand_Name, dbo.PURCHASESORDERBOM.ProjectSite,
                      dbo.PURCHASESORDER.LEDGERCODE, dbo.LEDGER.NAME, dbo.PURCHASESORDER.DATE AS Expr2, dbo.PURCHASESORDER.DELDATE,
                      dbo.PURCHASESORDER.Remarks, dbo.PURCHASESORDER.PARTYBILLNO, dbo.ITEM.ITEMCODE, dbo.ITEM.VAT,
                      dbo.PURCHASESORDERBOM.Reqision
FROM         dbo.PURCHASESORDERBOM INNER JOIN
                      dbo.ITEM ON dbo.PURCHASESORDERBOM.ITEMCODE = dbo.ITEM.ITEMCODE INNER JOIN
                      dbo.PURCHASESORDER ON dbo.PURCHASESORDERBOM.CINVNO = dbo.PURCHASESORDER.CINVNO INNER JOIN
                      dbo.LEDGER ON dbo.PURCHASESORDER.LEDGERCODE = dbo.LEDGER.LEDGERCODE