Another SQL question

[mvallevand]

Very elegant Martin unfortunately, there seems to be no guarantee that the EPG_EVENT oid is in the same sequence as start_time (at least not on my system)

Alex

Thanks, I was going to mention that the XMLTV source had to actually be in date order for that to work and for OTA EPG it might not but I didn't have any source to confirm.

Martin

[mvallevand]

Maybe this

select * from epg_event,
(select min(start_time) as start_time,channel_oid
from EPG_EVENT
where start_time > datetime('now')
group by channel_oid) next
where epg_event.start_time = next.start_time
and epg_event.channel_oid = next.channel_oid

Martin

[odin]

Maybe this

select * from epg_event,
(select min(start_time) as start_time,channel_oid
from EPG_EVENT
where start_time > datetime('now')
group by channel_oid) next
where epg_event.start_time = next.start_time
and epg_event.channel_oid = next.channel_oid

Martin

that only shows the 'next' on my system.

[bgowland]

Maybe this

Martin, I think you might have missed my post at #10 of this thread. It took a while to type as I was doing it between helping my wife with some chores and I think you missed it as you responded to Alex's post.

Cheers,
Brian

[mvallevand]

that only shows the 'next' on my system.

Wasn't that what bgowland asked for?

Martin