"Pramoda M. A" <pramod...@kpitcummins.com>
wrote in message
news:f7846b8f3c78c049b6a1dff861f6c16f0362f...@kcinblrexb01.kpit.com
> 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%');
If the inner select can ever return more than one row, you'd want
delete from table1 where ID in (
select ID from table2 where name like '%sqlite%');
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
