TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
SQL Query between Constituents & Objects
From:
David Lowe <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 22 May 2015 16:16:01 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (489 bytes) , text/html (643 bytes) 
I'm trying to generate a list of the ConstituentIDs for each Constituent
attached to an Object which has a Medium of Gelatin silver print. Anybody?
After years of working with TMS on the backend, I'm still not clear how or
where Constituents join Objects.... Eh.
Thanks,
david

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.

ATOM RSS1 RSS2