here's a table:
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 so the query should delete rows 8-12, but leave 1-2 intact (and also leave 3-7) there may be many other plID numbers is there some really great reference that y'all go to for crazy queries like this? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
