How can we combine SQL query and Qlikview Query

[#1]

This is the scenario

Table1:

Load

EMP_Id,

EMP_Name

SQL Select

emp_id,

emp_name

from employee;

temp_tabe:

load sal,emp_id

resident salry;

Table3:

load address

emp_id

resident table1;

The case is need to merge all the tables.

[#2 · Accepted solution]

Table1:

Load

EMP_Id,

EMP_Name

SQL Select

emp_id,

emp_name

from employee;

join(Table1) load

emp_id as _EMP_Id,

sal

resident salry;

join(Table1) load

emp_id as EMP_Id,

address

resident ???;

[#3]

Then will it create synthetic keys for emp_id?

[#4]

No it will not create the Synthetic key ...