how SQL condition "WHERE x in" from Qlik table?

[sdtfll]

I'm new to here, thanks advanced for your help,

Table1:

load * in line [

ID

1

2

3

];

I want to fetch records base on ID above, how to quote the IDs above in SQL?

Table2:

load ID, name, age, addr, salary 

SQL SELECT ID, name, age, addr FROM PERSON WHERE ID in [?? how? load Table1 ??];

[jwjackso · Accepted solution]

Use the Exists()  functions

Table2:

load ID, name, age, addr, salary

where Exists(ID);

SQL Select ID, name, age, addr FROM PERSON;