[thelist] SQL command help

[CDitty]

Thanks.  That found the missing record.

BIG THANKS

Chris

At 10:13 PM 11/12/00, you wrote:
>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 !
> >
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !