Narrow A First Set Of Records

Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) but have NO appointments in the last 6 months I am able to get the clients with >= 2 appointments with this query SELECT c.client_id,

Narrow A First Set Of Records

Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) of the set of “condition a” rows, which of those have NO appointments in the last 6 months I am able to get the clients with >= 2

Re: Narrow A First Set Of Records

Hi Don, On 17.12.15 16.14, Don Wieland wrote: Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) of the set of “condition a” rows, which of those have NO appointments in the last 6 months