>>Hi All,
>>
>>I have two tables which are identical in all respects; number of records, fields per record, and even the value of all fields except for the value of a particular datatime field. The records contain user access info, one record per user, and the datetime field contains the last access datetime.
>>
>>I need to extract from these two files the latest record only for each user. So either the record from file1 or from file2, whichever has the latest datetime access.
>>
>>I can obviously code this easily enough but was wondering if there was an easy one-liner SELECT statement or some such?
>>
>>Thanks,
>
>Did you consider a SELECT - SQL with UNION? This one will concatenate two identical structures vertically. I am not sure whether you can do everything with one single step, or perhaps it is easier to do it in two steps.
Thanks Hilmar. I will check it out.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.