Sender: |
|
Date: |
Tue, 16 Apr 2024 08:57:05 -0700 |
Reply-To: |
|
Subject: |
|
MIME-Version: |
1.0 |
Message-ID: |
|
In-Reply-To: |
|
Content-Type: |
multipart/alternative; boundary="000000000000b67a66061638ca79" |
From: |
|
Parts/Attachments: |
|
|
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.
|
|
|