Hello,
I need to know the Ids from Query B not in Query A. In other words Query A displays 100 records and Query B displays 80 records. I need the records missing from Query B.
regards !
p.s I'm trying the Cognos EXCEPTION by creating a 3rd empty query and then putting the QueryA (most records) on TOP and the QueryB (less records) on the bottom but error message even though i only have kept 2 data items on both queries (with different filters)
Add a join between Query A and Query b, with an outer join. Then in your query the records from Query A, with a filter of [Query B].[Data Item] is missing
Is this the same question (that got the same answer)?
https://stackoverflow.com/questions/64102239/cognos-11-filter-between-query-subjects
Thanks BigChris ! dougp, not aware about that link you mentioned but thanks for the info.