I have two tables, a Master table and a Details table. In the Master is one record per employee. In the Details table are multiple records for each employee. Each Details record is time and date stamped.
If I query the tables, I get all the records from both tables. How do I query the tables so that I get all the records from the Master and the most recent record (based on the time/date stamps) from the Details?
I appreciate any help that comes my way.
If I query the tables, I get all the records from both tables. How do I query the tables so that I get all the records from the Master and the most recent record (based on the time/date stamps) from the Details?
I appreciate any help that comes my way.