outer join in postgresql

[Anon]

The fields in oracle are
Where c.addr_group_id(+)=a.addr_group_id left
AND c.addressbook_id=aa.addressbook_id(+)
AND c.data_id(+)=d.data_id
AND d.data_id(+)=u.data_id

How do I do this in POstgresql because i have to use c.data_id twice, I\'ve tried

From addr_groups a left outer join addr_group_cards c ON c.addr_group_id=a.addr_group_id,
addr_group_cards c left outer join addressbook aa ON c.addressbook_id=aa.addressbook_id
addr_group_cards c left outer join datas d ON c.data_id=d.data_id
datas d left outer join users u ON d.data_id=u.data_id

so where should I put the parenthesis so it takes left outer join between c and aa table and c and d table

[[deleted]]

I suggest you first read the definition of LEFT OUTER JOIN for both oracle and postgres, to see if they do what you think they do.