Multiple product tables into one

[Rainy Pass]

I am trying to populate an order table with data from different product tables.

I have multiple Product tables, each has it’s own complex set of attributes and associated tables. What are my options for bringing them together into an OrderLineItem table?

[comment]

Very slim, I think. If those products cannot fit into the same table, you should consider a supertype/subtype model: each product has a "generic" record in the supertype Products table, and a related record in one of the more specific subtype tables.

[Rainy Pass]

I was afraid of that.

Can you explain the supertype/subtype model a little more? Or point me to more information?

Thanks

[comment]

There have been several threads about it (some of them very long). Do a search for "supertype" - and also for "Graham" with Fenton as the author.