table名等は適当です。
select * from nTable left join ( select * from leftTable inner join anyTable on leftTable.id = anyTable.leftTableId ) leftResult on nTable.any = leftResult.any
table名等は適当です。
select * from nTable left join ( select * from leftTable inner join anyTable on leftTable.id = anyTable.leftTableId ) leftResult on nTable.any = leftResult.any