I have been struggling with this one for the past week and I’m at my wits end. Please help!



I have a log table that I need to find all transactions where the transaction type is “Update Item” and the previous entry for the same serial number so that I can show what the item was update from and to. The table looks like this:

Trx_Log
--------------
Date
Trx_type
Serial_num
Condition
Owner

I think I need to use Top 2 in a sub-query somehow but I’m not sure of the proper syntax.

Any help you can offer will be appreciated.