 |
|||
Need help on oracle, query 3 tables
By: rekha singh | 08 Jun 2010 12:30 pm
Hi, 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,
|
