RE: joins

[Ben Johansen]

Well, you might be able to do this through ODBC   Setup an odbc definition to database 2 using the RBASE odbc driver Then in the database Use SCONNECT and SATTACH to create a table in database1 that is connected to database2 in the database1 schema Then create a view in Database 1 that uses the table from database1 and the table from database2   Might give you the answer you are looking for. ;-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Atrix Wolfe Sent: Friday, November 08, 2002 9:58 AM 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! (: