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.