left join with 2 resident tables

[#1]

Hi everybody,

i need to create a resident table T3 from 2 resident tables T1 and T2:

T1:

LOAD FIELD1 resident t0a;

T2:

LOAD FIELD2 resident t0b;

with a left join because i want all the values of FIELD1 associated with the FIELD2:

so T3 msut have 3 fields and must be similar to follow :

FIELD1     FIELD2   FIELD3

A                                0

B               B               1

C               C               1

Field3 must satisfy the condition ----> IF( FIELD1=FIELD2,1,0)

but how can i build the correct script?

I kindly ask you a help!!

Thanks in advance

bye

[fred_s]

Hi,

I'd love to help you but I don't understand your question.
Could you attach your file?

[#3]

LEFT JOIN means that only the fields of T1 will be kept:

1)

LEFT JOIN (T1)

Field2 as Field1,

Field2

Resident T2

2)

T3:

Load Field1, Field2,

   if(Field1=Field2, 1, 0) as Flag

Resident T1

Fabrice