库存查询SQL语句，用到的相关技术

Select 'POSINV' As DocTypeCode, h.InvoiceStatus As DocStatus, h.InvoiceNo As DocNo, h.MaskedInvoiceNo As ReferNo, h.InvoiceDate As TxDate, h.MarkDel HeaderMarkDel
, h.Shopcode As ReferShopCode, h.ShopCode As ActionShopCode, h.ShopMachineCode As MachineCode, d.PLU, d.QtySold As OrgQty, d.QtySold As FinialQty, -1 As Direction, d.MarkDel DetailMarkDel
From tblInvoiceH h Join tblInvoiceD d on h.ShopCode = d.ShopCode And h.InvoiceNo = d.InvoiceNo And h.SysID = d.InvoiceHSysID
UNION ALL
Select 'PO' DocTypeCode, poh.POStatus As DocStatus, poh.PoNo As DocNo, '' As ReferNo, poh.PORecDate As TxDate, poh.MarkDel HeaderMarkDel
, poh.OrderShopCode As ReferShopCode, pod.DlvyShopCode ActionShopCode, poh.MachineCode, pod.PLU, pod.SupplierQty As OrgQty, pod.RecSupplierQty As FinialQty, 1 As Direction, pod.MarkDel DetailMarkDel
From tblPOHeader poh Join tblPODetails pod on poh.OrderShopCode = pod.OrderShopCode And poh.PONO = p