Match em up
| From: | KPortsmout at aol dot com | Date: | Thu, 29 Mar 2001 17:17:03 +0000 |
| Subject: | Match em up | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-46124@lists.php.net to get a copy of this message | ||
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