I am trying to write query where I am trying to compare a value from one table with a value from second table where the value in the second table is in a row with some other values which is semicolon delimeted
example
table 1 : userid
row 1 prs
row 2 ppp
table2
useridlist
row1 ccc;ddd;eee;PRS;rrr
row2 qqq;www;ttt
so i need a query that takes value for row 1 ('prs') and compares it with useridlist of table 2 and since there is a match in row1 of table2 do not show it. then it takes row1 of table 1 and compares with useridlist of table2 and since there no match it shows.
Open in new window