AnsweredAssumed Answered

SQL Query?

Question asked by BruceHerbach on Feb 5, 2019
Latest reply on Feb 6, 2019 by fmpdude

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.

Outcomes