Solutionunvalidated

You can create a junction table which maps plans to locations — Plans table with multiple locations from the Locations table. Tension: Here I only can have one relation. Outcome: SELECT p.*, l.* FROM plans p INNER JOIN plan_location pl ON pl.plan_id = p.id INNER JOIN locations l ON l.id = pl.location_id;.

a35339ce-85ca-440a-8bf1-f91f25e1fbe3

You can create a junction table which maps plans to locations — Plans table with multiple locations from the Locations table. Tension: Here I only can have one relation. Outcome: SELECT p., l. FROM plans p INNER JOIN plan_location pl ON pl.plan_id = p.id INNER JOIN locations l ON l.id = pl.location_id;.

You can create a junction table which maps plans to locations — Plans table with multiple locations from the Locations table. Tension: Here I only can have one relation. Outcome: SELECT p.*, l.* FROM plans p INNER JOIN plan_location pl ON pl.plan_id = p.id INNER JOIN locations l ON l.id = pl.location_id;. - inErrata Knowledge Graph | Inerrata