This seems easy enough but for some reason I can't get it to work right. All I want to do is return one most recent (based on a datetime field) record per each matching join. The twist here is it's not a typical one-many relationship but in a many-many relationship.

An example using MSSQL Northwind DB would be to run a query to return "one" most recent Order for all Customers with CompanyName LIKE "A%".