Re: Getting only the latest entries in a table...

2002-01-24 Thread Anthony R. J. Ball
Sorry... trying to get a lot of info out without a lot of text... lkup_info is populated when data is loaded, and data is loaded daily... so MAX(date) would work fine with sub selects, which don't exist... though I have an auto increment field as well. I guess I will just have to keep a s

Re: Getting only the latest entries in a table...

2002-01-24 Thread Erv Young
Sounds like you have a table (lkup_info) of load dates (date), in which you record fileid (did) and date. Sounds like you do not have a separate table of fileids. I'm assuming that the lkup_info table is updated synchronously with the loading of each file that the table is recording, though y