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 <[email protected]>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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
