What version of MySQL are you running? The answer to your question depends on the version.
Rhino ----- Original Message ----- From: "A Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 9:00 AM Subject: Exists > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]