Hi R users.

sorry for missing example and if question is to general but I am wondering
if it is possible to execute subqueries in function sqlQuery (package RODBC)
with opened connection with Excel or SQL server 2000. I couldn't find any
example of this.

And if it is possible what should be a correct syntax for this query:

SELECT ct,COUNT(*) as n
FROM (SELECT COUNT(*) AS ct FROM children
GROUP BY family_id) AS x
GROUP BY ct;

sqlQuery(connecton, "     CORRECT SYNTAX     ")

(This query is an example from book Data Manipulation with R, Phil Spector,
page 47)

Thanks for any help

Andrija

	[[alternative HTML version deleted]]

