The 'aliases' also seem to work as long as I group my joins together in a certain order and enclose them in parens, something like this:

...
FROM Table1, Table2, (Table3 Alias3 INNER JOIN table4 ON ...)