RE: [PHP] MySQL advanced select?

>oh.. silly me, should have read the subject too. ;-) =) >Still .. are we talking about column names being different, or the values >for specific columns? Maybe paste your table definitions and explain more >specific what you want compared. The value inside the fields that are different form the values inside the other fields in an other table, but in the same database. Say that 10 times in a row ;) It's hard to explain, but what I'm looking for is this: -------------------------------------------------------- Database: userdata Table: tUserEmail Fields: userid int(11),email varchar(255) Table: tEmail Fields: mailid int(11), email_copy varchar(255), active tinyint(1) What I want is to select all values in "email" in table "tUserEmail" that is _not_ the same as any value in field "email_copy" in the table "tEmail". I want to sync the tables without having to select _all_ fields and then check if the value is the same or not. Do you know what I'm trying to say here? :) Thanks. /Magnus -------------------------------- >> > How do you select all fields in table 1 that are not the same as the >> > fields in table2? >> > Do you know what I mean? =) >> > >> > For example: >> > I want to select all e-mails in table tMail, field "mail", that are not >> > the same as in tUsersMail field "mail2".