After I read http://social.msdn.microsoft.com/Forums/en-US/60f55061-37f0-419d-914e-5ccbdf5941a8/4-access-tables-how-to-have-a-select-query-with-left-join-?forum=csharpgeneral in the forum. I think the easy way is to create a query in Access itself to test the query statement.
To create Query in Access 2013.
1. Click on the Create tab.
2. Choose either Query Wizard or Query Design.
3. Once you choose the 2 tables, right click the join and select Join Properties.
You should be able to see the query return from your statement.