News

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 ...
There must be some reason he's preferring the left join, though it's not obvious from the example. As far as equivalence, they're not going to have the same effect.