How to find the matching and non matching records from 2 tables

[harithareddy]

Hello All,

I have 2 tables assume table A and B in which id is the common filed, I need to compare table A id with B and need to get the non matching records count and matching records count.

Also in table B i have a status column for the id from table A i may have 2 or 3 transaction status and transaction numbers if all the status are passes then that particular should come in passed category if not it should come in failed category in the pivot or straight table created.

Let me give you a sample data

Table 1 :

ID      owner

100     A

102    B

103    C

401     D

Table 2:

ID     transid   status

100    1           pass

100    2           pass

102    5           failed

102    8           pass

103    4           failed

Now i need to get the output as

count of passed ids = 1 (100 is the ID)

Count of failed ids  = 2 (102 and 103)

count of not executed as = 1 ( 401)

Please help me in this.

Thanks in advance

[harithareddy]

Oh ok Andrey, I am not using inline load . I think you have attached the previous QVW , if possible can you attach the new one