search for: rd1500

...to exclude integer values from a small data frame 1, d1 that have matching hits in data frame 2, d2 (Very big) which involves matching those hits first. I am trying to use sqldf on the df's in the following fashion: df1: V1 12675 14753 16222 18765 df2: head(df2) V1 V2 13647 rd1500 14753 rd1580 15987 rd1590 16222 rd2020..... df1_new<-sqldf("select df1.V1, df2.V2 where rs10.V1 = d10.pos”) - Ideally I would like to try to use "delete" or not equal to "!=" though I can only find that delete works with sqldf. but it returns this error: Er...