Re: [sqlite] How to delete the rows which is the result of Select operation of another table?

On Tue, Feb 24, 2009 at 7:23 AM, Pramoda M. A 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] How to delete the rows which is the result of Select operation of another table?

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? With Regards Pramoda.M.A KPIT Cummins Infosystems Limited |