Query A versus Query B

[sanchoniathon]

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)

[BigChris]

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

[dougp]

Is this the same question (that got the same answer)?

https://stackoverflow.com/questions/64102239/cognos-11-filter-between-query-subjects

[sanchoniathon]

Thanks BigChris ! dougp, not aware about that link you mentioned but thanks for the info.