We're currently doing some clean up on our database. I'm wondering if there is a way I can make a query that will show me which constituents are linked to their church in our RE database, and which are not. Much of our information was carried over from CAMS system, which is what we used before RE, so many of the relationships didn't link.

 Any advice?

One quick way to do this it to make a Organization query using constituent ID = your church's consstituent record Id

Under output put relationships/individuals Name.

You cuold sort by the Individual relationship name if that would help.