Condition on multiple tables about jailer HOT 1 CLOSED

I can use 'Start Navigation Here' to turn sub table into main table but it only accept conditions on main table only, what I want is conditions on multiple tables.

This is not quite true. Whether tables are connected with inner or outer joins depends on which table you apply the "Query Builder" or "SQL Console" menu item to.
Tables to the left of it (the predecessors) are joined with an inner join, those to the right (successors) with an outer join.

As a general rule, you will see exactly those rows in the SQL Console that are also visible in the browser window in which you apply this menu item.

from jailer.