Query-expressions are called subqueries when used in WHERE or HAVING clauses. A subquery is a query-expression that is nested as part of another query-expression. A subquery selects one or more rows ...

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