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.