NoConcatenate Assistance - two table same information

[#1]

T_BDE_DAILY:

LOAD

[LOAN NUMBER],

[LOAN SETUP DATE],

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' and [Servicing Sold ID] <> 'NSM120110' and [Referral Code] <> 'CARC' ;

FINAL_TABLE:

LOAD DISTINCT

[LOAN NUMBER],

[LOAN SETUP DATE]

Resident T_BDE_DAILY;

drop table T_BDE_DAILY;

I NEED TO DO A NOCONCATENATE FROM THE T_BDE_DAILY WITH THE FOLLOWING WHERE CLAUSE

T_BDE_DAILY_TM;

LOAD

[LOAN NUMBER],

[LOAN SETUP DATE],

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' ;

SINCE I NEED T_BDE_DAILY IN THE FINAL TABLE LOGIC, I AM NOT SURE HOW TO INTEGRATE THE TWO TABLES AS WELL AS WHICH TABLE TO DROP IN THE FINAL TAB.

[#2]

Hi,

NoConcatenate -- use this

T_BDE_DAILY_TM;

Please check with this..

Sub2u

[#3]

Hi,

Synthetic table & Synthetic keys will be created in table viewer.

So try to avoid  that will change the column names or autonumber with the concatenate two fields...

Sub2u