[SOLVED] Querey help

[esiason14]

I have two tables

players 
[code] `player_id` smallint(5) unsigned NOT NULL auto_increment,
  `lname` varchar(50) default NULL,
  `fname` varchar(50) default NULL,
  `active` tinyint(1) unsigned default '1',
  PRIMARY KEY  (`player_id`)[/code]

AND

rosterplayers
[code]  `player_id` smallint(5) unsigned NOT NULL default '0',
  `team_id` smallint(5) unsigned default '0',
  PRIMARY KEY  (`player_id`)[/code]

Each has a player_id field.

What I want to do is retrieve a list of players that are NOT in the rosterplayers table. Make sense. I've tried several ways and it's just not working for me. Any help would be appreciated.

[shoz]

[code]
SELECT
p.*
FROM
playertable AS p
LEFT JOIN
rostertable AS r
ON
p.player_id = r.player_id
WHERE
r.player_id IS NULL
[/code]

[esiason14]

Thank you, sir. :)

[esiason14]

...and I just wanted to add. I do know how to spell "query". It was a typo in the title :(

[artacus]

Oh, I thought it was French :)