Subject | Re: Order by Going wrong |
---|---|
Author | rodbracher |
Post date | 2002-09-06T13:52:09Z |
IB6.0
What can be ambiguos once I changed the Order By... to
ORDER BY waybill.waydate, waybill.waybill ??
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
> >