Just as an aside, I do not bother with joins, if I can help it. If I need data
from multiple tables I query each table for just the data I need, and save it
in discreet arrays, 1 per table. Of course, my needs are pretty simple. I
typically have one parent table (the example suggested calls them
Hello Ken,
Thank you so much for your answer.
Your solution confirms what I had more or less in mind.
I will give it a try asap.
Best,
jbv
Le 2023-05-11 15:33, Ken Ray a écrit :
I would recommend a table for People, a table for Companies, and a
table for Employment that acts as a linking ta
I would recommend a table for People, a table for Companies, and a table for
Employment that acts as a linking table between the first two. Something like
(at its simplest):
people
id INT(11)
first_name VARCHAR(255)
last_name VARCHAR(255)
companies
Hi list,
This is a question for mySQL experts, which I am not.
I have a table of individuals.
I have another table of companies.
Many individuals have worked in more than 1 company with
different jobs descriptions.
I need to build my DB so that, with single requests, I
can get a list of either