query does not work

[pramoc]

hi this query doesnot work

a and b are both numbers

a b

1 1
2 2
3
4

str1 = "select b from [sheet1$] where b not in (Select a FROM [Sheet1$])"

[geekgirlau]

Where exactly are you trying to write this query?