selecting all but not if in another table

[jdubwelch]

This is my query to select bowl game info i need.

 

SELECT * FROM bowl_games bg  
LEFT OUTER JOIN bowl_teams t1 ON t1.team_id = bg.away_id 
LEFT OUTER JOIN bowl_teams t2 ON t2.team_id = bg.home_id
WHERE bg.date >= 1198310400 AND bg.date <= 1198396799
ORDER BY bg.bowl_game_id ASC

 

I have another table "winners": [winner_id] [game_id] [winner]

 

I want to select everything i am in my code above, except where the bg.bowl_game_id is in the winners.game_id column.

 

How do i do that?

 

 

[fenway]

You need to add another left join, and check where the join condition column IS NULL.