Atrix: Yes there certainly is. You need to look into the ODBC (open database connectivity) functionality that is available in R:Base and many other data-related products. With ODBC in R:Base you can be connected to one database and connect (using the SCONNECT command) to multiple databases and treat them all as if they were part of one massive database. You have access to all the views and tables in all the databases. You SATTACH tables and views from other databases. It is incredibly powerful. Older versions of the ODBC drive in R:Base were very slow but with the current version selecting data is very fast.
I'm not going to write a tutorial on this but dig into the manuals or on-line help and you should get enough information to get you going. Hope this helps. Mike Ramsour Voice 740-829-4340 -----Original Message----- From: Atrix Wolfe [mailto:atrix2@;cox.net] Sent: Friday, November 08, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: joins Theres no way to do a join with 2 tables in different DB's is there? I think i already know the answer to this one, but im hoping im wrong! (: ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
