Subject Re: [ib-support] JOIN the mess
Author Nando Dessena

S> select d.trkid, t.LeaseOpID
S> from disp_leg d
S> join Truck_ID t on d.TrkID = t.TrkID
S> group by d.trkid

S> Dynamic SQL Error
S> SQL error code = -104
S> invalid column reference

S> Can anyone point out my obvious mistake?

you can't include in the select list a column which is not part of
your group by list or is an aggregate expression.

Nando mailto:nandod@...