supported LEFT OUTER JOINS