Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
anybody??
When you join you need to find the data fields which you want as key values when you perform your join.
These data fields MUST be named with the same name.
All other fields MUST have different field names.
LEFT JOIN, RIGHT JOIN AND INNER JOIN works fine ......