Displaying 1 result from an estimated 1 matches for "cathree".
Did you mean:
athree
2013 Jun 10
1
Where Query in SQL
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 satisf...