Inner joins can be performed on up to 16 tables at a time, whereas outer joins (left, right, full) work on only two tables at a time. Joining Tables Manually If tables selected for joining have a ...

You can create an SQL view that contains the syntax of your query. You will use this view to create an outer join query. In the SQL QUERY TABLES window, select SAMPLE.EMPINFO and SAMPLE.SALARY from ...