Filter rows based on different tables

Hi,   I have a SALES table with many sales informations. And I have an SALES_ITEM table that has the sales items, they are linked by the SALES_ID field.   The problem is that in the SALES table I...