Let's assume I have 3 tables in a MySQL table with the following fields.
product
product_id
product_name
category
category_id
category_name
product_in_category
product_in_category_id
product_id
category_id
What query would you recommend to get a list of all products that are not currently assigned to a category in the "product_in_category" table?
Performance is very important, these tables are huge.