A.distinct B.limit C.ALL D.having
A.ALL B.both C.distinct D.different
A.LEFT OUTER JOIN B.RIGHT OUTER JOIN C.NATURAL JOIN D.INNER JOIN