Creation of a table using columns from different tables

[#1]

Hell Community member,

I have columns revcode,physname,adm,chargenumber,pattype from table1

and columns

doctorkey,doctorname,license no from from table2

Now I want to create a table3  containing the columns revcode,physname,admn,chargenumber,doctorkey,pattype , is it possible ?

Regards,

Ramesh

[#2]

Ramesh,

Are you sure Location is your right key to join these 2 tables?

What about ATTEND_DOCT_NO ?  Isn't it the same as CDK?

If it is, i would do

Doctors:

LOAD Location,
     CDK
FROM F:\POC_Project\POC\DCCDB_DATA_SDOCTOR.qvd (qvd);

[ACP Detail Charges]:
LOAD
Location,
    adm,
     pat_type,
     adm_date,
     phys_name,
    rev_code,
     Charge_Number,
     ATTEND_DOCT_NO,
     ATTEND_DOCT_NO as ID
FROM F:\POC_Project\POC\vwACPDetail_Charges.qvd (qvd);

Table3:
LOAD Location,CDK, CDK as ID Resident Doctors;
Join
LOAD * Resident [ACP Detail Charges];

If Location is your key, do the same with it instead

regards

Chris