Selecting distinct records

[Rob Burne]

Hi I am using this select statement to join two tables, waybill and waytrack.

SELECT
waybill.jobno, waybill.waybillno, waybill.dadd3, waybill.shipdate, waytrack.status, waytrack.date, waytrack.time
FROM waybill, waytrack
WHERE acctno = 'ROBIN'
AND waybilltype='C'
AND waybill.jobno = waytrack.jobno
ORDER BY waybill.shipdate DESC

I want to modify the query though, selecting only distinct waybill.waybillno records. If 2 records do exist with the same value for waybill.waybillno I want to select the latest entry (therefore sorting on the waytrack.date, and further waytrack.time in the event of the date being the same).

If anyone could help I would appreciate it.

Thanks,

Rob Burne.