Reducing query size - querying only data in one table that also appears on all other tables

Hello.   I have a 'Product' table, it has a 'Product Code' column and multiple attribute columns. It is an enormous data-set, as it has all the product a company as produced in its history.   In ...