SitePoint Sponsor

User Tag List

Results 1 to 25 of 63

Threaded View

  1. #38
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    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.

    Code:
    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;
    An ID field is typically used in a link (which display the actual name) or in a search form listing the different ShowTypes.

    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.
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •