<<< 6. 9. 2002 13:48 - rodbracher "rod@..." >>>


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