i have a "song" table S that has "songID", "playlistID", and "stale" (boolean) as columns (among others) i have a "playlist" table P that has "playlistID" and "songID" as columns (among others)
for a particular playlistID X, i want to delete all rows from P who's (P.playlistID == S.playlistID == X) and S.stale == true aaaaaaaaaah! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users