How to do left join on resident tables

[mahishah]

Hello, How to do left join on two resident tables in Qlik sense data load editor What is the syntax ?

Example 

table A has columns X and Y 

table B has column X and Z

i want table c with columns X,Y,Z

Thank you 

[Or · Accepted solution]

Table3:

Noconcatenate Load * Resident Table1;

Left Join

Load * Resident Table2;

You can then Drop table1 and table2 if they are no longer necessary.