On Fri, Nov 15, 2013 at 11:01 AM, David Cotter <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
