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]