Subject Re: Order by Going wrong
Author rodbracher
What is the difference - that IS what I had ???

--- In ib-support@y..., Roland Turcan <rolo@s...> wrote:
> <<< 6. 9. 2002 13:48 - rodbracher "rod@m..." >>>
>
>
> Try this SQL:
>
>
> 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 waybill.waydate, waybill.waybill
>
> --
> Best regards, TRoland
> http://www.rotursoft.sk