Join Question

[jduluc12]

Hi

May I have a load script that produces a Tables_3 in this manner?

Table_2 - Table_1 = Table_3.

Table_1

ID

1

4

5

Table_2

ID

1

2

3

4

5

6

Table_3:

ID

2

3

6

Thanks

Jean

[PrashantSangle · Accepted solution]

use not exist() like

Table1:

Load ID from Table1;

NoConcatenate

Load ID from Table2 where not exists(ID,ID);

Drop table Table1;

Regards,

Prashant Sangle