est a report on METX1 to show a full list of equipment with the following fields. Equipment Number, Description, Model Number, Serial Number, Manufacturer, Cal Due Date, Home Location, Accountable To, Checked out To and most recent Cal Cert Link.



select i4201 "Equipment Id", i4263 "Description", I4203 "Model No.", I4206 "Serial No", i4248 "Manufacturer",

C2303 "Cal Due Date", i4202 "Accountable Person", C2365 "Cert Link", I4299 "State",  L2801 "Checked Out", L2802 "Checked In" 

From mt.inventory left outer join mt.calibration on mt.inventory.mtag = mt.calibration.mtag 

Left outer Join mt.location on mt.inventory.mtag = mt.location.mtag where (C2339 is null or C2339 =1) and I4299 = 'A' 

and (L2815 is null or L2815 = 1)