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