[thelist] SQL command help
CDitty
mail at redhotsweeps.com
Sun Nov 12 12:19:35 CST 2000
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
More information about the thelist
mailing list