7 Replies Latest reply: Mar 9, 2018 10:41 AM by vamsee duggirala RSS

    When the synthetic keys are avoided using AS key, resuts produced seem in correct

    NEVILLE DHAMSIRI

      Dear All,

       

      I have linked two tables to produce results as I wanted. In the process, I am getting synthetic keys. (Branch_code & ME_CODE). But with synthetic keys, the results produced are ok. But I prefer expected results without  the synthetic keys. I did a left join too hoping to avoid synthetic keys but nothing happened. Will some one see where I have gone wrong & please correct me to get the expected results!

       

      Thanks

       

      Neville