Basically all I'm looking to do is to build a query like: SELECT * FROM [database1..table1] INNER JOIN [database2..table2] ON [database1..table1].key1 = [database2..table2].key2
Doug On Dec 15, 2:36 pm, Jeremy Evans <[email protected]> wrote: > 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.
