MySQL 4.0.14 regards
--- Rhino <[EMAIL PROTECTED]> wrote: > 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] > > > > > ____________________________________________________________ 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]