Getting rows of a table in single record

Thursday, July 10, 2014

I am completely new to programming I have a table with 2 column Key(Integer) and Values(Containing comma separated string) for example below



Table A
Key Values
1 1,2
2 3,4


I have another table again with 2 columns Key(Integer) and Value(single integer value)



Table B
Key Value
5 4
6 7
7 2
8 8


I am trying to get a all the Keys from table B whose values are not in Table A. Something like below .



Select * from B where Value not in (1,2,3,4)


Any suggestion or help is deeply appreciated.







http://ift.tt/1xZqGAV