| View previous topic :: View next topic |
| Author |
Message |
Tony Walsh
Guest
|
 Posted: Tue Feb 22, 2005 5:35 pm Post subject: How do I perform a query on 2 databases |
 |
|
Hi
the company I am working for have 2 separate databases servers for sales &
nominal (Sybase ASA V9). How do I write an SQLquery to create a join between
the 2 databases. I have done similar in the past (a long time ago) with
TQuery where the database name was incorporated into the table name within
the query. How would this work with SQLQuery
Thanks
|
|
| Back to top |
|
 |
Lasse
Guest
|
| Posted: Tue Feb 22, 2005 9:49 pm Post subject: Re: How do I perform a query on 2 databases |
|
|
Hi I am using ms sql, to do a join between different db I include the name
of the "seconday" database, in this example tor_vwab
dbo.ClientRole CR
Inner Join tor_vwab.dbo.Personx P ON P.type = CR.typeTOR
Lasse
"Tony Walsh" <tony-walsh (AT) dna-computers (DOT) co.uk> skrev i meddelandet
news:421b6d5d$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hi
the company I am working for have 2 separate databases servers for sales &
nominal (Sybase ASA V9). How do I write an SQLquery to create a join
between the 2 databases. I have done similar in the past (a long time ago)
with TQuery where the database name was incorporated into the table name
within the query. How would this work with SQLQuery
Thanks
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
