>select AlertFlg as Alert, Status as St, PageNo, Warehouse_Pref as Whse, > ItemMst.ProdFam, PItems.Itemno as SKU, Description, QoH, TotalDue as Due, > NJBuyQty,NJPurchQty as NJBought, NVBuyQty, NVPurchQty as NVBought, NextPODate, > ProdType.Descpt as Type, History.NJUseable as NJQOH, History.NVUseable as NVQOH, > pitems.BO, DueNJ as NJDue, DueNV as RenoDue, AvailInv as Avail, DemCanL as L, > DemCan4 as '4', DemCan8 as '8', R13, history.DemCan13 as '13', DemCan26 as '26', > DemCan52 as '52', ListPrice as List, PVC, SVC, isnull(acostrec, 0) as LCP, > amswebprice as AMSWeb, amscatprice as AMSCat, zzsellprice as zZounds, > sdmprice as SameDay, amzamsprice as AMSAmazSell, amzzzprice as zZAmazSell, > PV, PVB as PVDate, SVB as SVDate, SV, PVItemNo as PVSKU, UPCNo, RSSku, AmsEmp, > zZ1, zZ2, SD1, SD2, OverSzd, ExclPH, ExtraPH, PO1, PO1Date, PO1Qty, PO2, > PO2Date, PO2Qty, PO3, PO3Date, PO3Qty, PO4, PO4Date, PO4Qty, > targetprice as Target, WirelessFlg as Wireless, BuyInCase, CaseQty, pitems.EDPNO >from itemmst, history, forecast, poffers, prodtype, VendorMst, pitems >full outer join plastpo on pitems.edpno = plastpo.edpno >where pitems.edpno = itemmst.edpno >and pitems.edpno = history.edpno >and prodtype.codno = itemmst.prodtype >and pitems.edpno = forecast.edpno >and pitems.edpno = poffers.edpno >and PV = VendorMst.VendNo >and pitems.pvb = 'Mike' >>