[thelist] SQL View: Join? SubQuery?

[Susan Wallace]

Greetings!

I am trying to put together a View in MS-SQL. At this point, I am just
looking for a push in the right direction so that I can use trial and error
to learn this syntax, because it will come up again. :)

Here are the Tables I have:

Compositions
	CompID
	ComposerName
	CompositionTitle

Programs
	Venue
	Date
	Conductor
	PerformedPieces

The field Performed Pieces in Programs is a list (1, 287, 543, 2)
where each list item would match the CompID from Composers, etc

The end result needs to be a completed Program Record, where all fields are
shown, including the Title and Composer Name from Compositions. For example:

Venue: Jones Hall, Houston Texas
Date: August 20, 2002
Conductor: Elmer Fudd
Performed Pieces:
Composition in A Minor (for Marimba) - Bugs Bunny
Corino Falso - Eliades Ochoa
Camp Hill Comrade - Harland Mitchell

Should I be looking at using a Subquery in the View for this, or a Join? or
something else? Or is this just a bad idea? ;)

Thanks for your help!
Susan Wallace

<tip type="mailing lists">
If you are working with an ISP that is going to setup a mailing list for
the purpose of sending out say, store announcements, make sure that they
set the list properties so that replies to messages sent on the list go to
the list owner instead of the entire list. This will keep down the "I don't
care what you have on sale" messages that come back (and forth) if someone
does not want to be on the list.
</tip>