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]

Reply via email to