okay i realize my requirements were wrong, here's a better summary: the plID (playlist ID) in the song table is different (the OLD id 33), the plID in the playlist table is the new ID 35, so i have to test them separately. the song ID's must match the playlist table's index is the plID, so i guess that's what i have to select to delete? is that what's wrong below?
and here's the statement i came up with, it executes without error but does nothing to my tables: DELETE FROM playlist WHERE EXISTS ( SELECT 1 FROM song WHERE playlist.soID = song.soID AND song.plID = 33 AND song.Stal ) AND playlist.plID = 35 hmmm, oh SQLite, you so opaque! stop it! -------------------------------------------------------------------------- kJams: Mac and Windows Karaoke: CD+G Rip, Mix & Burn! Main: http://kjams.com/wiki/ Downloads: http://kjams.com/downloads/ What's New: http://kjams.com/history/ To Unsubscribe: Simply reply with "kJams: unsubscribe" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
