Paul,

Thanks for your reply again. Because of some load issues I was not been able to try the query out as yet but it makes sense logically and it should...

Thanks for your replies. Paul you are absolutely right that the tricky part is rule#3. I am having difficulty with this rule. I'll try your query and will let you...

Thanks for your reply Remi. The expected result in the above example should be:

Case.........Client........Age.........Inc Code

------------------------------------------------

125...........598...........68..........Y

125...........599...........33..........A

127..........600............22..........A

127..........600............22..........X 

Case#125 is counted because both the clients are valid clients. The first...