Help me. I have the following tables as an example, but actually there are many fields here just put 3 id(20,25,35). Clarified this, let's go to the example: I have table1, which has id and name of table_2 as shown below:
How do I group all the fields except id_table2 and name. the result that I would need would be: that for each id of table 1 it shows me all the id and name of table 2
here my query:
SELECT t1.*, t2.id, t2.nombre
FROM tabla_1 AS t1
INNER JOIN t2 AS t2 ON t2.id_tabla2 = t1.id