Excellent Karthik

2nd Query works perfectly fine, but there is a problom in first query as this wont handle case where there is only 1 active client for an ID....example

ID...

thanks to karthikeyan and ken.....i tested both the ways...both of them works great...

thanks again 🙂