Skip to Content
avatar image
Former Member

Multiple left outer joins...

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 21, 2015 at 07:51 PM

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

    Use that to create your above query.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 08:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 04:06 AM

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


    Join.PNG (8.9 kB)
    Add comment
    10|10000 characters needed characters exceeded