On Fri, Nov 15, 2013 at 11:01 AM, David Cotter <da...@adobe.com> wrote:
> what about "playlistID=X" ? > > the playlist table has "playlistID", (different playlists) > i only want the ones in a particular playlist > > So add "AND playlistID=$x" to the WHERE clause. DELETE FROM playlist WHERE EXISTS(SELECT 1 FROM songlist WHERE playlist.playlistID=songlist.playlistID AND songlist.stale) AND playlistId=$x; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users