I want to compare the OPT value in Table1 with the code value in another table.

[LTCTHITA]

Hay,....

I want to compare the OPT value that exists with the code value in another table, but I can't do it. I cannot fetch the array from the code table.

I can only fetch one row of the array.

I noticed that when I enter the OPT value that matches the value in the array, it shows that no data was found.

I need to create the array myself in order to display the data as needed.

I have multiple OPT columns that I want to compare, and I need to compare each one individually with the data.

My database : SQL server