Re: [R] subqueries in sqlQuery function (package RODBC)

2011-08-10 Thread andrija djurovic
I thought subqueries in sense of commad inside the command (in my example two select commands). It works as you proposed an I thought in this case (subqueries) that I need different syntax for sqlQury function combining SQL query and paste. But now I have another problem and again sorry if it is t

Re: [R] subqueries in sqlQuery function (package RODBC)

2011-08-10 Thread Prof Brian Ripley
In what sense is this a 'subquery'? It is just an SQL command (write it on one line, no terminating ;, which is not part of the query). On Wed, 10 Aug 2011, andrija djurovic wrote: Hi R users. sorry for missing example and if question is to general but I am wondering if it is possible to exe