Might be missing the point here, but can it not be done with a subquery? Something like this:
PHP Code:SELECT SSN
FROM EmploymentRecords
WHERE DoS In (SELECT Min(DoS) AS FirstDate FROM EmploymentRecords GROUP BY SSN)
Printable View
Might be missing the point here, but can it not be done with a subquery? Something like this:
PHP Code:SELECT SSN
FROM EmploymentRecords
WHERE DoS In (SELECT Min(DoS) AS FirstDate FROM EmploymentRecords GROUP BY SSN)