Hello all,
I have this two tables : table1,table2 . I would like to include all emails from
table2 into table1 removing duplicates.
INSERT INTO table1 (email) SELECT email from table2 where table1.email <>
table2.email;
MYSQL says: ERROR 1109: Unknown table 'table1' in where clause
Both tables exist, what's wrong?
TIA
Regards
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php