Dear Master,
Need help to compare 3 tables in oracle
Example like this :
3 tables are :
1. onnet
2. offnet
3. international
each files, contains like below :
5 628970215721
3 628970502888
2 628970726183
1 628970734887
..........
first column are total, last column are numbers
Now we would like to have result like below
Numbers onnet offnet international total
628970215721 5 1 2 8
628970502888 3 13 2 18
628970726183 2 14 3 19
628970734887 1 14 4 19
Please advice,
Thank you.
Best regards,
Romy
[Non-text portions of this message have been removed]
