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 ...

You can also join tables that have missing values. For example, ID 3 is missing from Table B. A left join outputs all the names in Table A (the left table) and matches them to the available salary ...