MS Access Left Function in SQL Query and VBA Code

Ms Access Left Join function or sometimes called Left Outer Join is the SQL function to join two tables, but only return the result of first table and the matches one with the second table. Look at the picture below for easier understanding: If we using Left Join function, the result will be: A, B,

source http://database.access-templates.com/ms-access-left-function-in-sql-query-and-vba-code.html