Having problem with join

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

Note the order of the where clause tables:

Code:

---

SQL> select * from xxx;

        ID LOCATION
---------- ----------
        1 AAAA
        2 BBB
        3 BBBB
        4 DDDD

SQL> select * from yyy;

        ID LOCATION
---------- ----------
        1 AAAA
        2 BBB

SQL> select a.id, a.location
  2  from xxx a, yyy b
  3  where b.id = a.id (+);

        ID LOCATION
---------- ----------
        1 AAAA
        2 BBB

SQL> select a.id, a.location
  2  from xxx a, yyy b
  3  where a.id = b.id (+);

        ID LOCATION
---------- ----------
        1 AAAA
        2 BBB
        3 BBBB
        4 DDDD

---

Thanks - Great Job