Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I specify a join for 2 databases?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00271651
Message ID:
00271798
Views:
22
>SELECT db1!transaction.item, db2!inventory.description JOIN db1!transaction.item=db2!inventory.item FROM db1!transaction ...
>
>SELECT transaction.item, inventory.description
>FROM db1..transaction transaction, db2..inventory.item inventory
>where transaction.item=inventory.item
>
>If the databases are in different servers/boxes you will not be able to run this query
>db1..transaction can also be written as db1.dbo.transaction
> db1..transaction ->transaction is the alias name

Thanks! Is it always "dbo" or is that the database name?
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform