you guys are flippin' gods ya know that right? thanks!
On Jun 19, 2014, at 10:26 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > 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