Identify and delete None Matching Data (associations)
I have two tables, one with sales orders and one with product-information.
They are connected through a Product ID. However only some of the product IDs are involved in sale transactions. This means that there are some product IDS which exists in the Product-table but not in the sales table. I want to delete the products (entire row) for the products that haven´t been involved in a sale transaction.
So ending result will be a modified product table with only products that have at least one sales transaction. (and sales table will stay the same).