For example, the Customers table has been filtered so that Subscribers receive only French customers (with the filter: country ...

For example, the Customers table has been filtered so that Subscribers receive only French customers (with the filter: country = ‘France'). To extend that filter so that the Orders table contains only orders for the French customers, enter the join statement: Customers.cust_id = Orders.cust_id