simple query help [solved]

[digitalgod]

I'm trying to display everything in 1 table that's not in another table.

[code]
<?php
$sql='SELECT * FROM djs WHERE name NOT
?>
[/code]

I need to select all the djs from the djs table that are not in the djsweek table... how can I do that?

[mrome]

Would have been a bit more help if you gave us the the columns of both tables. This will get u started.

SELECT *
FROM djs
WHERE NOT EXISTS
(

SELECT *
FROM djsweek
WHERE djsweek.name = djs.name

)

[digitalgod]

I tried that but it gave me an error....

the columns of both tables match but I just need to check the names

[digitalgod]

nevermind my bad, had a 'name' too many in there

thanks!