select a.xxx,b.yyy from table1 a, table2 b
where a.xxx(+) = b.yyy;


The result I want is to pick up all the entries in table1 a even if it doesn't match with table2