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?
You can chain joins quite easily:
SELECT ... FROM a LEFT JOIN b on a.somefield=b.somefield LEFT JOIN c on b.otherfield=c.otherfield