I have 2 tables. The 1st is system and the second is actions. The relationship is multiple records from the actions table for every record in the system table. I want to run a query selecting all the data from the system table and only the last action from the action table. I have a date field in the action table. Is this possible? How can I do this?