Add qualified joins to query syntax

Revert association join being LEFT OUTER