Re: join between two tables of 2 differents databases mounted on 2 differents servers

What error code are you getting? Please post the exact SQL statement you are trying to issue along with the exact error code and error messages.

Thanks,
Brian

Laurent RUHLMANN wrote:
>
> Hi,
>
> I would like to to create a join select statement between 2 tables each one
> being on different databases and different servers. I have created a link
> between the two databases but the remote table is not recognised when I do
> the select statement.
>
> Any idea ?
>
> Thanks,
>
> Laurent

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"