Thread: accessing two in one query?
View Single Post
  #2  
Old 03-29-2007, 03:50 AM
evy evy is offline
Senior Member
  
Join Date: Oct 2006
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
evy is on a distinguished road
Default Re: accessing two in one query?
If having databases on two different servers, use Federated tables to access them both from one query. If having tables with the same name in two different databases, use aliases to access them both from one query. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - accessing two in one query?
Thread: accessing two in one query?
View Single Post
  #2  
Old 03-29-2007, 03:50 AM
evy evy is offline
Senior Member
  
Join Date: Oct 2006
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
evy is on a distinguished road
Default Re: accessing two in one query?
If having databases on two different servers, use Federated tables to access them both from one query. If having tables with the same name in two different databases, use aliases to access them both from one query. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote