Hey all
I am trying to use where in clause in sql query in R
here is my code:
sql.select<-paste("select PERSON_NAME from UNITS where UNIT_ID in
('",cathree,"')",sep="")
where cathree is 1 variable with 16 observations as follows
UNIT_ID
1 205
2 209
3 213
4 217
5 228
6 232
7 236
8 240
9 245
10 249
11 253
12 257
13 268
14 272
15 276
16 280
but when i run this code, 0 rows are selected eventhough there exist 3 rows
which satisfy the above query
Thanks
Sneha
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
