If certain fields with a one-to-many relationship (such as constituency codes) are used in the filters, the results will only show that particular field value in the results of the query.

For example, if you filter on Constituency Code Long Description Equals 'Board Member' and place the Constituency Code field in the Output of the query, only the 'Board Member' constituency will display for the record in the query results for constituents with more than one constituency code.

To see multiple constituency codes for the records, use the query in a constituent export and select the constituency code fields on the Output tab.