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.