Hi, How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
regards
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
