Question regarding key in left join

[#1]

Hello all!

I think this is an easy question for you. What key is used in this left join? Both CurrencyCode and %CurrPeriod? or one of them?

Br,

Cristian

tmpTable:
LOAD Product, Date, %CurrPeriod,CurrencyCode, InvoicedValue
FROM qvd\ODS.qvd (qvd);
PrimeConv:
LOAD CurrencyCode, %CurrPeriod,round(AverageRate, 0.0001) as Rate
FROM qvd\Currency.qvd (qvd);
LEFT JOIN (tmpTable)
LOAD * RESIDENT PrimeConv;
DROP TABLE PrimeConv;

[Oleg_Troyansky]

All identical field names will be used as join keys. In your example, it looks like both fields will be used as join keys.

[#3]

In Left Join , it will work like full outer join and match the indentical keys fro join......

As Oleg told i think both the field will work