How to do a hierarchical query to MySQL (as in mongoDb)?

How to make a query against a table with a link, for example
TableA:
id
row
row2
to
TableB
A_id
id
row
row2
TableC
B_id
row 
row2

Something like this at the same time getting an answer as to Mongo as if retaining the hierarchy FROM A table to N
that is not the final response of the chain and all
September 19th 19 at 12:46
1 answer
September 19th 19 at 12:48
Solution
inner join

select * from TableA
inner join TableB
on TableA.id = TableB.A_id
inner join TableC
on TableB.id = TableC.B_id

Find more questions by tags MySQL