I'd like to delete multiple rows using the following syntax, but experiment appears to show that at most one row is deleted. I tried the following:
delete from addressbook where absid=(select personnick from grouplinks where groupnick='27') The 'select personnick ...' can return zero, one, or many results, and I'd like to have the 'delete from ...' delete zero, one, or many rows from the addressbook table. How can I do that with a single statement in SQLite, or is it not possible? -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users