join test
SELECT *
FROM ( SELECT 1 COL1, 100 COL2 FROM DUAL
UNION ALL SELECT 2 COL2, 300 COL2 FROM DUAL
UNION ALL SELECT 4 COL2, 300 COL2 FROM DUAL
) A
,( SELECT 1 COL1 FROM DUAL
UNION ALL SELECT 2 COL2 FROM DUAL
UNION ALL SELECT 3 COL2 FROM DUAL
UNION ALL SELECT 4 COL2 FROM DUAL
) B
WHERE B.COL1 = A.COL1(+)
