Compare 2 fields & display both records.

[divya_anand]

Hi all,

I am seeking a solution where I can compare the fields code1 & code 2 which belong to same table and if it matches then the output should be both the keys.

For eg. in the below screenshot, since 111 matches in code1 & code2, It should display "A01" and "B02".

Can someone please help me here.

Thank you very much.

[tamilarasu]

Hi Divya,

No problem. If you got the solution, please close the thread by marking Sunny's reply as correct answer. Have a good day.