loading conditional records from a tabel

[JACKNIEKERK]

2 tabels

1  names of customers  

2 sales of customers

at  (re)loading the database customers now i get all customers wich exist

load
DebNum,
DebName ;
SQL SELECT * FROM DEBNAW;

even if not any sales in sales tabel:

Load
Customer as DebNum,
ItemId,
Sales as Euro;
SQL select * from SALES ;

So how to  set the load statement in Customers to read only customers who have any sales in the SALES tabel

[lironbaram · Accepted solution]

you can do like this 

Sales:

Load
Customer as DebNum,
ItemId,
Sales as Euro;
SQL select * from SALES ;

left keep (Sales)

load
DebNum,
DebName ;
SQL SELECT * FROM DEBNAW;

[JACKNIEKERK]

Works fine!!  Thanks