Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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