-- INNER JOIN , OUTER JOIN 을 쓸때만 ON절을 쓸수있습니다. WITH T1 AS ( SELECT '1' A UNION ALL SELECT '2' A ) , T2 AS ( SELECT '1' A , 'A' B UNION ALL SELECT '1' A , 'B' B UNION ALL SELECT '2' A , 'A' B UNION ALL SELECT '2' A , 'B' B UNION ALL SELECT '2' A , 'C' B ) -- ANSI JOIN SELECT * FROM T1 INNER JOIN T2 ON T1.A = T2.2