Actually, your query is illegal in std SQL, but some
implementations allow it because it's efficient in some
special cases (where it happens to give meaningful results).
The only columns strictly allowed in the column list after
"select" are the columns listed in the group-by clause.
Any others (tempo, in your case) will return random values
from that particular group.
You need to do something like
select tm.track_id, mn.time, tm.tempo
from tempo_map tm,
(select track_id, min(time) time from tempo_map group by track_id) mn
where tm.track_id=mn.track_id and tm.time=mn.time
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
