Hi,
SELECT a.list FROM db1 a, db2 b WHERE a.email!=b.email;
this shoulds work
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: [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]
