Is it possible to include an inner join within a series of left joins?
In other words:
Select TableA.* FROM TableA LEFT JOIN TableB ON TableA.x=TableB.x LEFT JOIN ???? (TableC INNER JOIN TableD WHERE TableC.y > TableDy)
I put the question marks to indicate that I THINK I need some sort of alias for the subsequent inner join (if this is even possible…).