Join with 3Tables

select e.event_title,b.branchname from events e join EVENTS_BRANCH_RELATION eb on e.event_id=eb.event_id join branches b on b.id=eb.branch_id


Here EVENTS_BRANCH_RELATION table contains branchid and event_id