--- In ib-support@yahoogroups.com, Lucas Franzen <luc@r...> wrote:

>
> Scott,
>
>
> > select d.trkid, t.LeaseOpID
> > from disp_leg d
> > join Truck_ID t on d.TrkID = t.TrkID
> > group by d.trkid
>
> in general:
> Every column you have in select clause taht is NOT a statistic function
> (SUM, COUNT, etc.) MUST have a corresponding entry in the group by
> clause.

Thanks Luc,

I knew I was missing the simply obvious. :)

Cheers.

Scott.