Subject Re: Order by Going wrong
Author rodbracher
IB6.0

What can be ambiguos once I changed the Order By... to
ORDER BY waybill.waydate, waybill.waybill ??

--- In ib-support@y..., "rogervellacott" <rvellacott@p...> wrote:
> Is this an ambiguity problem? Are you using IB or an earlier
verion
>
> --- In ib-support@y..., "rodbracher" <rod@m...> wrote:
> > In my app I have the query : ( invoice actually a param )
> >
> > SELECT waybill.waybill, waybill.waydate, ETC
> > FROM waybill
> > LEFT OUTER JOIN place ON (waybill.destplace = place.place)
> > LEFT OUTER JOIN pod ON (waybill.waybill = pod.waybill)
> >
> > WHERE invoice = 65259
> >
> > ORDER BY waydate, waybill
> >
Changed to...
> >
> > ORDER BY waybill.waydate, waybill.waybill
> >