Report Query on two sets of data

Guru Balachandra shared this question 3 years ago
Answered

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

ABC123

XYZ123


table B has 2 records for each of the above entry

ABC123, OPEN

ABC123, CLOSED

XYZ123, OPEN

XYZ123, PEND

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..

Comments (3)

photo
1

Hi Guru,

Thanks for the explanation.

Please see the attached video, I have developed the report.

Let me know if I got it wrong or if you have any questions.

Regards,

Mahesh

Files: 7938.mp4
photo
1

Hi Guru,

Hope you are doing well.

Can you please let me know if you have any questions?

Regards,

Mahesh

photo
1

Hi Guru,

Hope you are doing well.

I will mark this ticket as completed for the moment. If you have any questions on this ticket please reply back.

Regards,

Mahesh