I want to come up with an SQL query that returns a list of client names were the client has had two types of services with in a specific date range.
Client table has ID and FullName fields
Services Table has ServiceDate and ServiceType fields
The result I want is a list of Client FullNames who have had two service records within a data range >= 1/1/2018, <= 12/31/2018 were service type for one service is FP and the second is FNRC
Is it possible to combine this into a single query? I can see doing this as two queries, one for each service and looping through the result looking for matches.
Assistance/suggestions on what the query would look like would be greatly appreciated.