[thelist] SQL command help

[CDitty]

I need to search through 2 sql tables and fine 1 entry that is missing.  I 
know how to compare the two tables together where they match, but how can I 
get where they don't?

Here is the sql for what I know how to do.
select bonus_plays.user_id, lottouser.id
from bonus_plays, lottouser
where bonus_plays.user_id = lottouser.id

All I need to do is find the 1 row that is missing from the bonus_plays 
table.  Can anyone help?

Thanks

Chris