How to count same records from two tables

[rkpatelqlikview]

Hi

can anyone please give me a clarity on this.

Please find the attached sample document.

There are 2 tables. One is Sub and another is Master.

Sub table having the fields Tid, Vnum, Status, Dnum,Date.

Master table is having fields Dnum, Vnum, Date.  This Master table having all the missed Dnum's from Sub.

Sub table is missed some Dnum's.

I need to count the number of entries of Dnum's with Sub  and with out Sub from the Master table.

Please suggest.

Thanks in advance.

[karthikoffi27se]

Hi Kumar,

You can concatenate two tables and then count the Dnum's. This will give the count from two tables.

Many Thanks

Karthik

[rkpatelqlikview]

Thanks for your quick response Karthik.

Need to count matched Dnum's and Unmatched Dnum's from the both tables.

how to achieve this?

After concatination its showing like below Nulls.

[arvind1494]

count(master.Dnum)-count(sub.Dnum)  will give you entries without sub

and

count(sub.Dnum) will give entries with a sub

[tamilarasu]

Hello Kumar,

Please look at the attached file and let us know whether this is your requirement or not.

[techvarun · Accepted solution]

Please check the attached helps.

If not share the expected results

[rkpatelqlikview]

Correct one. Thanks for your support

[43918084]

Would you mind to share the file Comm-289555.qvw    for this solution?