bberkovich of 1800 Radiator
4/12/2016 - 6:16 PM

PO (Shipping) Tracking Numbers (from ASN)

PO (Shipping) Tracking Numbers (from ASN)

SELECT PM.POID 
	,PM.VendorID
	,V.VendorName 
	,PM.POOrderDate
	,PM.Warehouseid
	,ASN.AsnShipped
	,ASN.AsnCarrier
	,ASN.AsnTrackingNo
FROM gxWizmo_24.dbo.POMASTER PM
	--JOIN gxWizmo_24.dbo.POMASTERPODETAIL PMD
	--  ON PM.POID = PMD.POID
	LEFT JOIN gxWizmo_24.dbo.ASN ASN
	  ON PM.POID = ASN.POID
	JOIN gxWizmo_24.dbo.VENDOR V
	  ON PM.VendorID = V.VendorId
WHERE PM.POOrderDate >= GETDATE() - 180