How do I limit the load of data in one file based on the content of another table?

[#1]

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?

[#2]

hi - tried it and am getting an error. Oracle may not like that syntax. Any ideas?

[pover]

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