I have the following tables: tblCustomer, tblProductA and tblProductB. I have also an order table
tblOrder. Each order consists of a customer and one or more products from tblProductA and one or more products tblProductB.
The standard case is when we have only one table for products, and we usually use a join table to connect orders and products.
However, in the case I am bringing, it is mandatory to have two tables for products (tblProductA and tblProductB). How do I model this case?