On Tue, Feb 24, 2009 at 7:23 AM, Pramoda M. A <pramod...@kpitcummins.com> wrote: > Dear All, > > > > I have to delete the rows of one table table but key is the result of > select operation of another table? > > > > Delete from table1 where ID = ( > > > Select ID from table2 where name like '%sqlite%'); > > > > Is it ok? >
did you try it? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users