Updating table2.field from table1.field

[eyespark]

Hi

I have another newbie question for the comunnity. I have 2 tables (let us say table1 and table2) in my database, both have email field. I would like to import emails from table1.email into table2.email but only those that are not already in table2.email. How would php look like? :glare:

Thanks in advance

[Roger_Ramjet]

PHP would not look like :p
SQL query would look like

// update matching record
$query = "UPDATE table2 t2 INNER JOIN table1 t1 ON (t2.someID=t1.someID) SET t2.email=t1.email WHERE t2.email IS NULL";  

If you need a different answer it's because you should have asked a different question. Like

How do I add records to a table but ensure that emails are unique?
answer: Unique index on emails column

[eyespark]

Aaaah, thank you. Will try that.