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.
| Author |
Topic |
|
bobz_0585
Yak Posting Veteran
55 Posts |
 Posted - 2009-03-25 : 02:48:15
|
| hey alli am trying to query from a stored Procedure found from a remote server...and join the results with data found on a table another database.... my sql statment looked like that:select col1,col2,..,local.colx from openquery(LSname,'exec storedproc') where openquery(LSname,'exec storedproc').colx=local.colxi know it is wrong..please help |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-25 : 05:00:45
|
| select col1,col2,..,l.colx from openquery(LSname,'exec storedproc') ajoin local l on a.colx=l.colx |
 |
|
|
|
|
|
linked server and join