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

[Pramoda M. A]

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 | Bengaluru | Board: +91 80 30783905

 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users