On Dec 15, 10:47 am, Doug Tykocki <[email protected]> wrote: > Hey everyone, > > Is it possible to perform a cross database join such as: > > table1 = DB1[:table1] > table2 = DB2[:table2] > > table1.join(table2, :key1 => :key2) > > Or, do I have to resort to a string literal query? I'm working with > some legacy schemas and we love cross database streams from time to > time. > > I'm running SQL Server 2005 with Sequel 3.30
If you can tell me how to express what you want in SQL (i.e. you set up external database access inside one of the databases), I can give you the appropriate Sequel code. If you are asking for Sequel to do the join in ruby land, Sequel doesn't do that (it's an SQL database library, not a relational algebra library). Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
