Read this SQL tutorial ... differs from an INNER JOIN or an implied JOIN. An INNER JOIN will only return rows for which there is data in both tables. Compare the following query after using ...

Creating a Query View You can create an SQL view that contains the syntax of your query. You will use this view to create an outer join query. This WHERE expression creates an inner join of EMPINFO ...