I have a DB table like below

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

ID FID MDate ...

thanks for the reply. i may have asked question in incorrect way. i will try explain again.

i want to get those FID which are active, if any one FID...