TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show Text 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:
Query
From:
Adrián Pérez Camarena <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 30 May 2018 18:10:06 -0400
Content-Type:
text/plain
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