>Thank you, Godfrey. I thought I tried this syntax and I did use LEFT JOIN but not LEFT OUTER JOIN. Maybe this will make a difference.
This is completely optional; both are equivalent. From the help (emphasis is mine):
"LEFT [OUTER] JOIN specifies that the query result contains all rows from the table to the left of the JOIN keyword and only matching rows from the table to the right of the JOIN keyword.
The OUTER keyword is optional; it can be included to emphasize that an outer join is created."
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
