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]
