added support for LEFT OUTER JOIN