Re: Use select within delete

2007-11-14 Thread Dario Hernan
k addison <[EMAIL PROTECTED]> wrote: > > > > Dario Hernan wrote: > > > Hi all I need to delete some fields from a table but in the where > > > clause I need to put a select command. > > > For instance, delete from table1 where id=(select id from table2 whe

Use select within delete

2007-11-13 Thread Dario Hernan
Hi all I need to delete some fields from a table but in the where clause I need to put a select command. For instance, delete from table1 where id=(select id from table2 where datehttp://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]