Re: How do I retrieve just the latest record in a Table ?

Bruce,

use a subselect:

Select * from Table
Where rec='EGLL'
Or rec='EGQS'
Or rec='EGQL'
etc etc....
where Report_time = (select max(Report_time) from Table

            where rec='EGLL'
            Or rec='EGQS'
            Or rec='EGQL'
            etc etc....)

Jack Received on Mon Aug 17 1998 - 01:51:22 CDT