I use RODBC as my conduit from R to SQL. It works well when the tables are
stored on one channel, e.g.,

channel <- odbcConnect("data_base_01", uid="....", dsn="....")

However, I often need to match tables across multiple databases, e.g.,
"data_base_01" and "data_base_02". However, odbcConnect() appears limited
insofar as you may only query from tables within a single channel, e.g.,
database. I do not have access to write and create new tables on the SQL
servers, which is a possible solution (e.g., copy all tables into a single
database).

Is there any way, in RODBC or another R-friendly SQL package, to perform SQL
operations across multiple databases?

Warm regards.

-- 
Tom Schenk Jr.
tomschenkjr@gmail.com

	[[alternative HTML version deleted]]


