"Pramoda M. A" <[email protected]>
wrote in message
news:[email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
