Page Comparison

SELECT
 j.ObjectNumber objectNumber,
 l.LocationString currLocation,
 o.Handler handlerString,
 h.MTB_ConstituentID1,h.MTB_ConstituentID2,h.MTB_ConstituentID3,h.MTB_ConstituentID4,h.MTB_ConstituentID5,
 o.TransDate locationDate,
 p.LocPurpose reasonForMove,
 o.AnticipEndDate plannedRemovalDate,
 o.DateOut removalDate,
 o.SearchContainer currentLocationNote,
 l.LocationID locationShortID,
 o.CrateID,
 (case when o.Inactive = 1 then 'active' else 'deleted' end) miscStatus
FROM
 ObjLocations o
 JOIN LocHandlers h ON h.Handler = o.Handler
 JOIN Locations l ON l.LocationID = o.LocationID
 JOIN Objects j ON j.ObjectID = o.ComponentID
 JOIN LocPurposes p ON p.LocPurposeID = o.LocPurposeID
 ORDER BY locationDate;
;