can't seem to wrap my brain around this one. I have 2 tables and i want to insert information from the one table to the other but only where the information doesn't already exist.
this is what ive been playing with so far. Am i completely off track? any help appreciated.
mysql_query("INSERT INTO table1 (name) SELECT name FROM table2 WHERE table1.name != table2.name")