Is there a way to get joined tables as array?
I have a user table, education table and work experience table:
users
id
first_name
last_name
education
user_id
name
start_year
end_year
workexperience
user_id
name
start_year
end_year
Now I want to get a nice overview of all education and work experience of
a person.
When using regular joins, I will get a lot of rows, since the number of
educations and work experiences will multiply the number of rows.
The best case would be if I get the id, first_name and last_name only
once, with another array inside with the educations and work experiences.
Could anyone point me in the right direction please?
No comments:
Post a Comment