[thelist] SQL command help

Michele Wandrei michele at inthree.com
Sun Nov 12 22:13:23 CST 2000


This is what works for me (using your table names):

SELECT lottouser.id, bonus_plays.user_id
FROM lottouser
LEFT JOIN bonus_plays ON lottouser.id = bonus_plays.user_id
WHERE bonus_plays.user_id IS NULL

Hope this helps.
___________________________________________________
Michele Wandrei
inThree Design
www.inthree.com



----- Original Message -----
From: "CDitty" <mail at redhotsweeps.com>
To: <thelist at lists.evolt.org>
Sent: Sunday, November 12, 2000 1:16 PM
Subject: [thelist] SQL command help


> 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
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>





More information about the thelist mailing list