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?