Two kinds of products and one order table 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?
There are 2 options:


If your productType has same attribute:

If your ProductType has different attribute: