If you want to restrict the tuples you get from 'broadcasts' use AND instead of WHERE.
Cheers /rudy -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 15:42 To: Wayne Helman Cc: [EMAIL PROTECTED] Subject: Re: Multiple Join Issue Leave off the 'WHERE e.Game_ID is NULL' Wayne Helman wrote: >How would one join multiple table and selected all >records from a joined table whether they exist OR not? >I can get the records if they exist in a second table >and I can get the records if they don't exist, but is >there a way to combine the two? > >I have, for example, a statement like this (selects >where doesn't exist): >SELECT > c.Game_Date AS Date, > c.Game_Time AS Time, > a.Team_Name AS Home_Team, > b.Team_Name AS Away_Team, > e.Game_ID > FROM schedule c > JOIN Teams a ON c.Home_Team = a.ID > JOIN Teams b ON c.Away_Team = b.ID > LEFT JOIN broadcasts e ON c.ID = e.Game_ID WHERE >e.Game_ID IS NULL > >Any ideas? > >______________________________________________________________________ >Post your free ad now! http://personals.yahoo.ca > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
