When running a query that doesn't seem to be producing a correct result, the criteria that excludes revenue records where the constituent does not exist in the defined selection does not appear to be working. The query results include revenue records that should have been excluded based on the "constituent exists in ..." criteria.
We're currently evaluating this issue for a fix in a future patch or service pack.
Steps to Duplicate
1. Select Ad-hoc query from the Analysis functional area 2. Click add > Ad-hoc query 3. Source view = Revenue 4. Click Ok 5. Criteria: Constituents\Selections\Exists in "bbtest" is equal to No 6. Add Constituent\Lookup ID to the output 7. Run the query and export the results