outside of the parens? shouldn't it go inside the parens? eg: say the playlist ID i want is "57", would i do this?
also: what is the "1" for?
sorry for my newb-ness, still learning! but fun!
DELETE FROM playlist
WHERE EXISTS(SELECT 1 FROM songlist
WHERE playlist.playlistID=songlist.playlistID
AND playlist.playlistID=57
AND songlist.stale)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
