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]


On Tue, Apr 16, 2024 at 7:59 AM David Lowe <[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] 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.