TableA:
orgcode | orgname | Orgtype | address |
1 | tata | Mnc | aaa |
2 | birla | Mnc | bbb |
4 | jindal | Mnc | ccc |
TableB:
Personcode | title | firstname | lastname |
1 | dr | Sandeepa | Rout |
2 | mr | Debashish | rout |
4 | dr | Surekha | Nayak |
TableC:
Orgcode | Personcode | Primaryaddress |
1 | 1 | xx |
2 | 2 | yy |
4 | 4 | zz |
Table1:
Orgcode | Orgname | Orgtypename | Address |
1 | Tata | Mnc | aaa |
2 | Birla | Mnc | bbb |
3 | L&T | Mnc | eee |
4 | Jindal | Mnc | ccc |
5 | Adani | Mnc | ddd |
6 | Wipro | Mnc | fff |
Table2:
Personcode | Title | Firstname | Lastname |
1 | dr | Sandeepa | Rout |
2 | mr | Debashish | Rout |
3 | dr | Sandeep | Sahoo |
4 | dr | Surekha | Nayak |
5 | dr | Abhimanyu | Rout |
6 | dr | Laxmipriya | Nayak |
Table3:
Orgcode | Personcode | Primaryaddress |
1 | 1 | xxx |
2 | 2 | yyy |
3 | 3 | aaa |
4 | 4 | zzz |
5 | 5 | bbb |
6 | 6 | ccc |
Output should be:
Personcode | tableA.orgcode | Table1.orgcode | tableA.orgname | Table1.orgname | matched |
1 | 1 | 1 | Tata | tata | matched |
2 | 2 | 2 | Birla | birla | matched |
3 | -- | 3 | -- | L&T | unmatched |
4 | 4 | 4 | Jindal | jindal | mathced |
5 | -- | 5 | -- | adani | unmatched |
6 | -- | 6 | -- | wipro | unmatched |
It means 1st we have to join tableA, tableb, tablec to one(tabA). Then table1, table2, table3 to one (Tab1).
Then we have to compare TabA and Tab1.
But We have to compare orgcode against personcode.
Also we have to create a listbox as Matched where two options should be displayed. If we will click on matched or unmatched it will display accordingly..
Please note: the matched field in output table is a label not a predefined field..
Kindly suggest what to do...
