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!

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

Multiple database select

Status
Not open for further replies.
tmanportland

tmanportland

Programmer
Joined
Oct 23, 2003
Messages
1
Location
US
I have multiple databases all with the same structure. What I want to do is query all databases at the same time. My query works fine if I only attempt one database. Any suggestions on how to reference multiple data files?

Thanks
 
Status
Not open for further replies.

Similar threads

joeb007
  • Locked
  • Question Question
select statement :sybase getdate
Replies
1
Views
363
blom0344
blom0344
Rubicks
  • Locked
  • Question Question
Time Dimension With Multiple Sets for Different Fiscal Year Definition
Replies
1
Views
358
RiverGuy
RiverGuy
misscrf
  • Locked
  • Question Question
SQL 2005 Database Diagram in Visio 2003?
Replies
1
Views
209
mrdenny
mrdenny
M8tt
  • Locked
  • Question Question
Measure Showing multiple decimal places
Replies
2
Views
220
M8tt
M8tt
shandads
  • Locked
  • Question Question
Multiple Time Dimensions SQL 2005
Replies
2
Views
154
MDXer
MDXer

Part and Inventory Search

Sponsor

Back
Top