Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

loading conditional records from a tabel

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

 

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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;

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Creator
Creator
Author

Works fine!!  Thanks