On 6/20/2014 1:20 AM, David M. Cotter wrote:
i want to delete from the table all records with plID = 1, but ONLY those that have a corresponding record where plID == 851090 and where that record's soID matches the one where plID = 1
delete from MyTable where plID = 1 and soID in ( select t2.soID from MyTable t2 where t2.plID = 851090 ); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
