On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
> 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
>
select db1.table1.email from db1.table1 left join db2.table2 on
db1.table1.email=db2.table2.email where db2.table2.email is null;
regards,
thalis
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php