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. If you
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.
However,
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
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