Joining two tables

[#1]

T_BDE_DAILY:

NoConcatenate
LOAD [Loan Number],
[Fips County Code]

RESIDENT
T_BDE_DAILY_tmp     

drop table T_BDE_DAILY_tmp;

T_County_Temp:
LOAD
county_fips,
county as CountyName

FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt(txt, codepage is 1252, embedded labels, delimiter is '', msq)
where county_fips >000

Produces 2 tables

T_BDE_DAILY

T_County_Temp

I need to left join T_County_Temp to T_BDE_Daily.  I need to keep T_BDE_Daily and drop T_County_Temp

[Gysbert_Wassenaar]

If county_fips contains the same values as [Fips County Code] then try:

T_BDE_DAILY:

NoConcatenate
LOAD[Loan Number],
[Fips County Code]

RESIDENT
T_BDE_DAILY_tmp     

drop table T_BDE_DAILY_tmp;

LEFT JOIN(T_BDE_DAILY)

LOAD
county_fips as [Fips County Code],
county as CountyName
FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt

(txt, codepage is 1252, embeddedlabels, delimiter is '', msq)
where county_fips >000

Or even better don't join at all:

MapCountry:

mapping LOAD
county_fips as [Fips County Code],
county as CountyName
FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt

(txt, codepage is 1252, embeddedlabels, delimiter is '', msq)
where county_fips >000

T_BDE_DAILY:

NoConcatenate
LOAD[Loan Number],
[Fips County Code],

ApplyMap('MapCounty',[Fips County Code]) as CountyName

RESIDENT
T_BDE_DAILY_tmp; 

drop table T_BDE_DAILY_tmp;

[tamilarasu]

You need a common key field between two tables..

A:

Load A1,

B1

From

Source1;

left join(A)

Load B1,

C1

From

source2;

if your key field is not same then type like fieldname as B1.. hope this helps you..