Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting stuff from a different database?

Status
Not open for further replies.

NSMan

Technical User
Aug 26, 2004
72
US
How can I say "select animal from database1.eatenanimals where database2.whatateit='dog' and database2link=database1id.

 
Refer to other databases this way: DataBaseName.OwnerName.TableName.
Then join the two tables with your link columns. Need more help, provide the actual column names, etc.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top