Query is a way to group records; it is not a reporting module. The query output shows you whether the record belongs in the query. If a field with a one-to-many relationship (such as constituency codes) is in the filters or output, the record appears multiple times, once for each time the record meets the criteria. This allows you to check your query to ensure you get the expected results.

Once the correct records are grouped together in a query, it can be included in a report, export, or mailing to eliminate duplicate results.