[Solved] Find minimum datetime while using FK in two different tables
[ad_1] With 2 courses you are always going to get 2 rows when joining like this. It will give you the minimum date value for each course. The first way you can get a single row is to use TOP 1 in your query, which will simply give you the course with the earliest test … Read more