Results 1 to 25 of 63
Feb 20, 2002, 18:03 #38
- Join Date
- Jan 2001
- Milton Keynes, UK
- 0 Post(s)
- 0 Thread(s)
If you want to data on a particular ShowType then it's just a matter of JOINing the relevant tables.
The query below returns some basic data for every Show that is of ShowType XXX, where XXX represents the ShowTypeID of the required ShowType . The ShowTypeID has been used but the Show.TypeName could be used but would require a further JOIN using the ShowType table.
SELECT S.ShowName, S.ShowDate, S.ShowTime, S.ShowDesc FROM Show AS S INNER JOIN (Artist AS A INNER JOIN ArtistShow AS [AS] ON A.ArtistID = [AS].ArtistID) ON S.ShowID = AS.ShowID WHERE S.ShowTypeID = XXX;
Attached is the db diagram.
As for DB courses, I think if you can find a decent one it'd be worth it (here's the one I took). Having said that many of the people I work with haven't any formal DB design training but are very knowledgable and skilled. Experience counts for a lot.