Jump to content

selecting all but not if in another table


jdubwelch

Recommended Posts

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?

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.