Hypothetically, let's say that I have three tables:
- Products (id, product_name, added_timestamp) - Individuals (id, name, last_name) - Companies (id, company_name, company_number, company_address)
Now, let's say that both individuals and companies can add their products to my virtual shop.
Now, let's say I want to display all the added products sorted from descending order by the
Products.added_timestamp column. However, I don't know how to connect Products with Individuals and Companies and display all the data.
How would I approach this problem?