Report Query on two sets of data
I have a table with one unique key. lets say table A with primary key INC.
I have another table B (with two columns , Foreign key to table A i.e. INC, another column : Status) which holds multiple records (relational records) for every entry in table A.
I want to display an output which says show me all records in a table A for which has doesn't have any occurrence of specific status.
e.g. table A has 2 records
table B has 2 records for each of the above entry
I need to create a report which show me all records which doesn't contain an occurrence of status CLOSED. i.e. it should return me XYZ123
Hope my query is clear..