Hi,
I need help on right outer join query
select * from PO_mstr
right outer join voucher_mstr on PO_mstr.domain = voucher_mstr.domain and voucher_mstr.ref = PO_mstr.ref
this outer join is behaving like inner join, I need all records from voucher_mstr even when voucher_mstr.ref = PO_mstr.ref does not match.
Any suggestion will be helpfull
Thanks in advance.