Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Inner Join on Linked servers

Author  Topic 

kgundava
Yak Posting Veteran

66 Posts

Posted - 2011-08-03 : 08:34:25
Hi All,
I am getting some wierd results if i do an an inner join on two tables ( one in a linked server and the other one in sql server) .Please see the query below and let me know if the syntax has anything to do with..
select T.[AIDATEP] from TEST..TED.[CRIS] as T inner join CRIS as S on T.[AIDATEP] = S.[AIDATEP]
Thanks...

theboyholty
Posting Yak Master

226 Posts

Posted - 2011-08-03 : 10:05:55
I can't see anything obviously wrong with your code.

What do you men by 'wierd results'?

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club
Go to Top of Page

kgundava
Yak Posting Veteran

66 Posts

Posted - 2011-08-03 : 11:48:23
Thanks for the reply.Sorry for not being clear enough.I posted a new thread with clear description ...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163844
Please let me know your thoughts...
Go to Top of Page
   

- Advertisement -