LEFT KEEP on three tables

[Black_Hole]

Hello all,

I have 3 tables and two primary keys. 

Please could you tell me how I can use the left keep function in the context below?

Table_1: CustomerID as key_1, name,  address

Table_2: ID as key_1, ISO, label, quantity

Table_3:  ISO, country, detail_address

Thank you in advance for your help.

[marcus_sommer · Accepted solution]

Pure technically it would be:

Table_1: load CustomerID as key_1, name,  address from a;

Table_2: left keep load ID as key_1, ISO, label, quantity from b;

Table_3:  left keep load ISO, country, detail_address from c;

But it couldn't be said if it's really suitable to your data and datamodel.

- Marcus