I am doing merge query of two constituent queries for the first time using "OR" operator. Then from database view used export to build a list. I found that some records were not in the export of data - at first thought it would be head of house situations - but after review of some records which did not have spouses realized that inactives were being suppressed in the merge query despite being included in both of the individual original queries.

My merge query from NXT record count was 445 records (static of course).

I re-ran the same merge query in database view and saved it and the count increased to 469.

Please get this resolved so that inactives are not automatically being suppressed from merge queries.