This certain MySQL database organisation 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?
You can approach this by creating the relevant foreign keys so you can use relations in your databases.
Here is a nice read about relational databases.
I strongly recommend it for you to read it, sou you can get the hang of the relational design idea.

Edit:
In your particular case i would to this:


Products (id, product_name, added_timestamp, seller_type, seller_id)
Individuals (id, name, last_name)
Companies (id, company_name, company_number, company_address)


where seller_type can be either 'i' as Individual or 'c' Company, and seller_id is the corresponding foreign id.