On Fri, 14 May 2004 14:00:46 +0100 (BST) A Z <[EMAIL PROTECTED]> wrote:
> 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) http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]