I don't investigate the error -- why don't you put a unique index
on email? That's how you get what you want.
> 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?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
