Load a table field where value appears in a previous table

[#1]

Hi

Every product has a supplier.  In my model, I have loaded a limited number of products based on some criteria.

I have a list of supplier names that I want to load into my model.  Currently I am getting a complete list even though some of them do not have a product (as it was already filtered out).

How can I filter them so I only get suppliers that have a product in the model?

Can I do a where clause based on a previous table...

Thanks

Oli

[Gysbert_Wassenaar · Accepted solution]

Yes, a where exists clause should do the job.

Products:

load productid, supplierid

from ...productsource...;

Suppliers:

load supplierid, suppliername

from ...suppliersource...

where exists(supplierid);

[#3]

Hi

Simple when you know how

Thanks