Multiple left outer joins...

[Former Member]

Hello All,

Can someone please help me to achieve the following in query transform.

and h.coverage_id = c.coverage_id(+)

and c.payor_id = epm.payor_id(+)

AND c.plan_id = epp.benefit_plan_id(+)

Thanks.

[Former Member]

Below screen shot is showing Inner Join for two tables. Like this you can join as per your requirement.

[former_member186894]

Join both h and c table in Query transform. double click on query transform go to FROM tab, join both the tables in Join Pairs according to your query.

-Imran

[Former Member]

On the From tab of query transform you have the outer joins (inner and left outer).

Use that to create your above query.