Re: [R] SQL Queries from Multiple Servers

2009-05-15 Thread Mark Wardle
Hi. Depending on your requirements, one option would be to do the join in R using merge() If you wish to run SQL joins across multiple databases, then it is not an R problem but a database problem. For a quick solution, I would write scripts that bring all your data together into one database (co

Re: [R] SQL Queries from Multiple Servers

2009-05-14 Thread Paul Gilbert
Tom Schenk Jr wrote: 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". H

Re: [R] SQL Queries from Multiple Servers

2009-05-13 Thread Jeff Newmiller
Tom Schenk Jr wrote: 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". H

[R] SQL Queries from Multiple Servers

2009-05-13 Thread Tom Schenk Jr
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() a