TMSUSERS Archives

The Museum System (TMS) Users

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

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

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="UTF-8"
Date:
Wed, 30 May 2018 18:10:06 -0400
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Query
Content-Transfer-Encoding:
quoted-printable
Message-ID:
<[log in to unmask]>
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
From:
Adrián Pérez Camarena <[log in to unmask]>
Parts/Attachments:
text/plain (16 lines) 
Dear friends,

I'm trying to pull out a list of records of the Objects table via a query of SQL Server. This list must contain the Constituents (Artist Name). I am wondering which tables and fields besides Objects table are involved to pull out the list I need, specially need to know which field in the Constituents table matches on a field in Obejcts table in order to link both fields and obtain the Artist name of every record that lives in Objects table. Or if there is another table involved besides Objects and constituents, I'll appreciate your advise


¡Thank you!

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