You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Difference between data table join.

    in Reporting and Analytics for HCM 2 comments

    Summary:

    Difference between data table join.

    Content (required):

    Hello All,


    I have some confusion on table joins. Please refer below example.

    I have two data tables.


    PER_ALL_ASSIGNMENTS_M PM,

    PER_ALL_PEOPLE_F PF

    where 

    PM.PERSON_ID = PF.PERSON_ID

    PM.PERSON_ID = PF.PERSON_ID(+)

    PM.PERSON_ID(+) = PF.PERSON_ID

    Can some one tell me what is difference between those three in where clause, and which one we will used mostly. Please explain briefly. 


    From my knowledge those are left join and right join.


    Thanks,

    Malak.


    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!