Retrieve data from two tables with indirect relation(from another table)

mysql, sql, subquery

Solution

select t.* from territory t
inner join region r on r.id = t.region_id
inner join devision d on d.name = r.division_id
where d.name = 'A'

Problem

I have 3 tables ``` Division id name 1 A 2 B Region Id name Divsion_id 01 Rim A Territory Id name region_id 001 a 01 002 b 01 003 c 01 ``` Now I want to write a query such way that user will select division and its respective territories should get displayed. How can I write this query, as there is no direct relation between Divsion and Region?

Original source