Datapull from multiple qvds

[aarohipatel]

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.

[aarohipatel]

Yes