Re: [PHP] Match em up

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 y

Re: [PHP] Match em up

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 tabl

[PHP] Match em up

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