You are here: Re: Joining tables in different databases « MsSQL Server « IT news, forums, messages
Re: Joining tables in different databases

Posted by MC on 01/24/06 17:04

Agreed, but why not provide a more complete info since theres a little
difference? He may need to pull data from two servers tomorrow...


MC


"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:LBqBf.4368$ft2.109590@news20.bellglobal.com...
> The OP said the two DB's were on the same server. Therefore, 3-part
> naming
> is sufficient.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
>
> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
> news:dr5cc8$bue$1@magcargo.vodatel.hr...
> Try 'four part names' :).
> server.database.owner.table
>
>
> MC
>
>
> "Captain Nemo" <nemo@nospam.com> wrote in message
> news:6oqBf.8267$wl.3901@text.news.blueyonder.co.uk...
>> Hi
>>
>> I'm working on an ASP project where the clients want to be able to
>> effectively perform SELECT queries joining tables from two different
>> databases (located on the same SQL-Server).
>>
>> Does this involve creating virtual tables that link to another database,
>> or
>> am I completely on the wrong track?
>>
>> Any hints as to where I might find more information (buzz-words, etc.)
>> would
>> be most appreciated.
>>
>> Thanks
>>
>>
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация