Should be simple

Transact-SQL
1

I am not trained in SQL, but know enough to create SIMPLE tables, but I can't figure this one out.

I need to combine my "Deals" table with my "Activity" table ("ID" = "Related To"), but I only want to show the most recent record from the "Activity" table ("Due Date").

I have all the activities linked, but can't figure out how to show just the latest record. I appreciate any help you all can provide.

2

For SQL Server:


SELECT D.ID, D.othercolumn1, D.othercolumn2, ..., A.somecolumn1, A.somecolumn2, ...
FROM Deals D
CROSS APPLY (
    SELECT TOP (1) *
    FROM Activity A
    WHERE A.ID = D.ID
    ORDER BY "Due Date" DESC
) AS A