Get data using join on many to many table

Question

I got 4 tables: galleries, areas, stores and gallery_element.

So I need to create a big query in which I could join the data(ex. name column) from galleries, areas, stores which are connected throug gallery_element table.

gallery_element has: id, gallery_id, area_id, store_id columns.

Can someone give me an simple example so I can practice with it further by myself.

Thanks!

Yeah I don't know very much sql so that's why I'm asking for help — Marinario Agalliu, Jan 31 '22 at 11:33
Is it hard to get it why I'm asking? And I'm asking just for an example and not a solution to my problem... — Marinario Agalliu, Jan 31 '22 at 11:34
No that's hibernate java, I'm asking for a simple solution in vanilla mysql. I could do join for a many two many with just to foreign keys but the problem here is that I have to join from many to many with 3 foreign keys — Marinario Agalliu, Jan 31 '22 at 11:36
select whatever from table join othertable on fk = pk join othertable2 on fk2 = pk2 join... — dcolazin, Jan 31 '22 at 11:37
Two tables, one join. Three tables, two joins. Four tables, three joins. etc — jarlh, Jan 31 '22 at 11:39
No sense doing all this (sending also minimal reproducible example). Take example from @Juranir how a community should help each other... — Marinario Agalliu, Jan 31 '22 at 11:39

score 2 · Accepted Answer · answered Jan 31 '22 at 11:37

I think it can help you to start your query:

select gallery_element.id, galleries.name, areas.name, stores.name from gallery_element
inner join galleries on galleries.id = gallery_element.galleries_id
inner join areas on areas.id = gallery_element.area_id
inner join stores on stores.id = gallery_element.store_id

Get data using join on many to many table

1 Answers1