Mysql multiple left join
===

We have one table say table A we left join with table B. This works fine. The issue here is that based on the left join of table A and B we would like to have another left join but between table B and table C because those fields are available only in this 2 table so what is best solution to build this query?