On Thu, 29 Mar 2001 19:58:51 +0200, Johannes Janson
([EMAIL PROTECTED]) wrote:
>Hi,
>
>SELECT a.list FROM db1 a, db2 b WHERE a.email!=b.email;
>
>this shoulds work
no, this isn't even close. you need a left join, there's an example
in the mysql docs under left join that shows you how to do what you
want.
- Mark
>Johannes
>
><[EMAIL PROTECTED]> schrieb im Newsbeitrag
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> 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: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: php-list-
>>[EMAIL PROTECTED]
>>
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: php-list-
>[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
