The initial problem is that the "OUTER" which is optional for a JOIN did not allow re-editing.
LEFT OUTER JOIN Vs LEFT JOIN <-- I realize this and was just letting you know...
What's more confusion is this error (see image) regarding Checkboxes when the fields are Varchar so not sure why this is happening as the fields are available.