List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:August 23 1999 4:34pm
Subject:Re: Smybolic Links as data
View as plain text  
Robert Canary wrote:
> 
> Hi,
> 
> I have not read anything about this , but ...............
> 
> I need to a field in a table to actually reference  the content in
> another field in another db.   Is this possible?

You can do a SELECT across DBs:
SELECT db1.t1.col, db2.t2.col FROM db1.t1, db2.t2
WHERE db1.t1.ref_col = db2.t2.ref_col;

  jim...
Thread
Smybolic Links as dataRobert Canary23 Aug
  • Re: Smybolic Links as dataJim Faucette23 Aug
  • Re: Smybolic Links as dataThimble Smith23 Aug
  • Re: Smybolic Links as dataRobert Canary23 Aug
    • Re: Smybolic Links as dataThimble Smith23 Aug
  • Enumerating rows and cumulating valuesDino25 Aug
    • Enumerating rows and cumulating valuessinisa25 Aug
    • Re: Enumerating rows and cumulating valuesMartin Ramsch13 Sep
      • Re: Enumerating rows and cumulating valuesManuel Coral A.16 Sep
        • Re: Enumerating rows and cumulating valuesJames Manning16 Sep
          • Re: Enumerating rows and cumulating valuesMartin Ramsch16 Sep
        • Re: Enumerating rows and cumulating valuesMartin Ramsch16 Sep