External Email - Exercise Caution
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: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,Collections Database Administrator
Fine Arts Museums of San Francisco
de Young \ Legion of Honor
50 Hagiwara Tea Garden Drive
San Francisco, CA 94118c 682.365.8457
p 415.750.8949
[log in to unmask]
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: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 Collectionsignoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.