Hi Chris,

it's my mistake I haven't checked the query. I was thinking of the joins. distinct to a specific coluln doesn't have any meaning.

if the query is like this

select * from hc0mstr a inner join (select rl0to#,rl0fr#
from rl0reln where rl0rltyp in('BILLNG','SERVCE',)
and rl0totyp in('PHY','MBX')) as b on a.hc0hc#=b.rl0fr# left outer join lc0mstr c on c.lc0lc#=b.rl0to#

Pls. help me to convert to Oracle

Regards

Arshad