How to make LEFT JOIN depend on a further INNER JOIN - ( Filtering a left join further )

Below is how to make LEFT JOIN depend further on an INNER JOIN. Below is an example of "using LEFT JOIN and INNER JOIN in the same query":

SELECT *

FROM TableFoo tf1

LEFT JOIN (TableBar tb1

  INNER JOIN TableBaz tb2 ON tb2.id = tb1.baz_id

) ON

  tb1.id = tf1.bar_id

In this example, tb1 will only be included if tb2 is also found.