I am using RODBC to query data from SQL SERVER.
How can I get both tables when the result contains two tables?

Currently my code is as follow

```
library(RODBC)
channel <- odbcDriverConnect("driver={SQL Server};server=xxxx;atabase=xx;uid=xx;pwd=xxx")
initdata<- sqlQuery(channel,paste("select * from roles;select * from seat"))
odbcClose(channel)

```

The initdata contains result only from table roles

In fact, my query is a stored procedure like "exec XXX" and the stored procedure returns multiple tables. I wonder if there is a way to get all the result tables.