Re: Match em up

On Thu, 29 Mar 2001 19:58:51 +0200, Johannes Janson (johannes.janson@gmx.de) 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 > ><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 >> > > > >-- >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