Let's try that again : expose the [number] column to the outer selection (** are for emphasis**):
( select id_song, **number** from ( select id_song, **number** from PLAYLIST_SONG where id_playlist=2 {and|or } number > 258 ) as MYPLAYLISTSONGS Regards Tim Romano On Tue, May 11, 2010 at 12:46 PM, Tim Romano <tim.romano...@gmail.com>wrote: > And you would put move your title-condition to the outer query: > > . > . > . > ) as SONGIDLIST > on SONG.id_song = SONGIDLIST.id_song > > where > your title-condition and|or your title-number condition > > > Regards > Tim Romano > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users