Re: Match em up
| From: | Johannes Janson | Date: | Thu, 29 Mar 2001 17:58:51 +0000 |
| Subject: | Re: Match em up | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-46130@lists.php.net to get a copy of this message | ||
Hi,
SELECT a.list FROM db1 a, db2 b WHERE a.email!=b.email;
this shoulds work
Johannes
<KPortsmout@aol.com> schrieb im Newsbeitrag
news:71.bf84daa.27f4c80f@aol.com...
> Hi,
>
> I have two database`s with one table in each. (MySQL)
>
> Is there a way that I can select data from one table and then match it
with
> the data in another and discard the results so all I am left with is the
> original data from the first table which never matched up.
>
> Database1
>
> EmailAddress
> RecID - Email
>
> Database2
>
> Members
> lots of stuff blah blah
> Email
>
> So I would match the Email from Database1 Table EmailAddress to those in
> Database2 Members. Take out the matches and be left with a list of people
who
> started signing up but never completed it. Any thoughts?
>
> Ade
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>