Displaying 1 result from an estimated 1 matches for "v1012".
Did you mean:
1012
2012 Mar 28
1
Is it possible to de-select with sqlQuery from the RODBC library?
...an illustrative example,
library(RODBC)
mdbConnect<-odbcConnectAccess("S:/data/ ... /databse.mdb")
data <- sqlQuery(mdbConnect, "select id, DOB, V1, V2, ..., V1009, V1011, V1013 from someTable")
I want everything in the table (someTable), except 'V1010' and 'V1012,' but I can't figure out how to make a negative or reverse SQL select statement. I have a lot of someTables and I have two or three variables in each table that I do not want R to fetch,
Is there a way to define a reverse select in SQL? One would imagine it would look something like this,...