'Pull all records from one table that have a minimum date in another table

I want to select all distinct contact records (and their contact data) whose first sale records are between 1/1/2021 and 12/31/2021

When I finally thought I had it I saw that it was not finding the records where the minimum sale date was between those days.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source