8 Replies Latest reply: Mar 22, 2018 2:43 PM by Manish Kachhia RSS

    Help me to get a the below answer

    Venkatesh Botla

      Hi Everyone,

       

      Please help me to get below answer

       

       

      example tables :

      table 1:

       

       

      id value
      1100
      2

      200

       

       

      table 2:

       

       

      id value
      150
      1100
      2200
      3150
      3200
      4250
      4300
      4350

       

       

      output:

       

       

      id value
      3150
      3200
      4250
      4300
      4350

       

      i have used where not Exists , i am getting one value for each id (it is giving unique values )

       

      My case i want all the values as like output.

       

      Can you suggest me something.

       

      Thanks