Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a file that contains all clients and am loading a tabe that contains all trades and I only want to load the clients if they have traded with us. The client ID appears in both the client file and the trade file.
How do I do this?
hi - tried it and am getting an error. Oracle may not like that syntax. Any ideas?
Exists() is not an Oracle function so doing will not work.
Oracle_Table:
Load * ;
SQL Select *
From ...
Where not exists(..);
Since it is a QV function you should put the where not exists below the load
Oracle_Table:
Load *
Where not exists(..);
SQL Select *
From ...;
Karl