In this SQL Server tip, Arthur Fuller explains the effects of NULLs, ... Here is the SQL to compare the inner and outer JOINs: SELECT InnerOuter.T1.T1ID, InnerOuter.T1.NameAS Name1, ...

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

This example illustrates a left outer join of the PROCLIB.PAYROLL and PROCLIB.PAYROLL2 tables. proc sql outobs=10; title 'Most Current Jobcode and Salary Information'; select p.IdNumber, p.Jobcode, ...