>The way your current EXISTS is written doesn't correlate with the parent table, which is wrong. If you want to check for existence of such child for the parent you need to add
>
>and Child.Fk = Parent.PK into your exists test.
Not in that case, I need to verify if a user has particular records in a child table. That will determine if he is allowed to get the parent. In that example, I harded NoMember=1. But, in reality, this would be a parameter, but again, hardcoded for the user who is logged, and not dependant on some data from the parent table. The only corelation which is needed is to assure that records returned from the parent table, has the NoClient value in at least one of the user subscribed forum.