Constituent paid for another constituent to have a membership. In query both constituents are showing as active members, though only one constituent has the membership listed on their constituent page.
Ensure that within the membership query filter that: Member > is dropped = No and Member > Membership > Status = Active, to show all members that are active.
Steps to Duplicate
1. Click Analysis tab 2. Click Information Library 3. Search for Query: 4. Click Edit Definition 5. Add Include records where: Lookup ID is equal to x 6. See Status = Active 7. Click Constituent tab 8. Search Constituent 9. Click Membership tab 10. See Constituent has no memberships