Hello,
I have 3 QVD' s that I have loaded for 3 separate applications.
Now, I want to use those 3 qvd's in a new application so that I can see all the data in one single application instead of 3 different applications.
PREM.QVD has the following fields:
1. KEY
2. ACCOUNT_NAME
3.ACCOUNT_ADDRESS
4.TECHNICIAN_NAME
5.TECHNICIAN_ADDRESS
6.NUMBER
7. TERM
8. MONTHLY_PREMIUM
INF.QVD has the following fields:
1. KEY
2. ACCOUNT_NAME
3.ACCOUNT_ADDRESS
4.TECHNICIAN_NAME
5.TECHNICIAN_ADDRESS
6. NUM
7. TERM
8. INF_PREMIUM
RET.QVD has the following fields:
1. KEY
2. ACCOUNT_NAME
3.ACCOUNT_ADDRESS
4.TECHNICIAN_NAME
5.TECHNICIAN_ADDRESS
6. NUM
7. TERM
8. RET_NUM_AMT
9. RET_DEN_AMT
I want to do a full outer join and pull all the fields PREM.QVD
and 'INF_PREMIUM' from INF.qvd
and 'RET_NUM_AMT', 'RET_DEN_AMT' from RET.qvd
Please advise on how to do a full outer join?
Thank you in advance.
