Sampling from three tables by one request?

Question

PHP

Hi all!
There are 3 tables, presented figuratively.

You need to infer the type, for example:

1. Apple is green, sweet, medium
   
2. Orange is yellow, sweet
   

etc.
I'm trying to make a selection in one query from three tables.
It turned out to pull out the type_id list, through GROUP_CONCAT, but I can’t pull out the type list in any way!
Tell me who knows how?

SELECT t1.*, GROUP_CONCAT(t2.type_id ORDER BY t2.id ASC SEPARATOR ',') AS type_id 
FROM fruits t1 
LEFT JOIN types t2 ON t2. type_id = t1. fruit_id 
GROUP BY t1.id

Thank you!

Answer 1

Subquery? ) Or a question of optimality?
I would take Group_Concat to a higher level, and connect this query with another connection to the connections table, i.e. the third alias would replace id with names.

Answer 2

SELECT *, (SELECT GROUP_CONCAT(type SEPARATOR ',') FROM connections AS c LEFT JOIN types AS t ON c.type_id = t.id  WHERE  c.fruit_id = f.id) FROM fruits AS f;