-
Pls Help me to convert this DB2 query to Oracle
select * from hc0mstr a inner join (select distinct(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#
I am using inner join first then a left outerjoin
Thanx
arshad
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|