Hi!
Sorry for the late reply, but I was away for a one week work/vacation
trip to Rio.
> "Richard" == Richard Reina <[EMAIL PROTECTED]> writes:
Richard> Steve,
Richard> I never received Mr. Van Engen's response. I appreciate your response.
Richard> However, my question remains unanswered
The problem is that the value returned for a column requested
in a group query without an agregate function is undefined,
There is NO associated link between some column that you
didn't put in the function and one that does not appear
in the group by statement.. In fact usually (in my databases
How about :
select a.flight_no, a.sequence, a.city
from stop_offs a left join stop_offs b
on b.sequence = a.sequence + 1 and a.flight_no = b.flight_no
where b.sequence is NULL;
Richard Reina wrote:
>
> Steve,
>
> I never received Mr. Van Engen's response. I appreciate your response.
> Howeve
Steve,
I never received Mr. Van Engen's response. I appreciate your response.
However, my question remains unanswered. If you put "sequence" in the
GROUP BY it does not give you the value that correspond to the MAXIMUM
sequence. As a matter of fact I can't find any combination of values
that
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.
Richard Reina wrote:
>
> I posted t
I posted this question to this list on Saturday. I realize that not
everyone on the list knows whether this query is possible using MySQL.
However, if I could please here back from someone who does know, I would
appreciate it. I'm getting flack from informix ( and other DBMS ) users
on my perl
