External Email - Exercise Caution Hi David, is this what you're looking for? SELECT top 10 O.ObjectNumber, C.ComponentNumber, OL.TransDate, L.LocationString, CR.CrateNumber from Objects O LEFT JOIN ObjComponents C on C.ObjectID = O.ObjectID LEFT JOIN ObjLocations OL on OL.ObjLocationID = C.CurrentObjLocID LEFT JOIN Locations L on L.LocationID = OL.LocationID LEFT JOIN Crates CR on CR.CrateID = OL.CrateID Best, Kathleen Huang Forrest Collections Database Administrator Fine Arts Museums of San Francisco de Young \ Legion of Honor 50 Hagiwara Tea Garden Drive San Francisco, CA 94118 c 682.365.8457 p 415.750.8949 [log in to unmask]<mailto:[log in to unmask]> On Tue, Apr 16, 2024 at 7:59 AM David Lowe <[log in to unmask]<mailto:[log in to unmask]>> wrote: External Email - Exercise Caution Hi all, I'm pretty confounded by the tables involved in querying Object Locations. I managed to get Home Location, but I'm needing Current with the date of the change. Has anybody done this? Best, David David Lowe | The New York Public Library Specialist III, Photography Collection To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.