Tim,

I would like to do some selection on the remote side and then join the rest of the tables
locally.  How is a query executed when it contains a mix of local and remote database tables?

Leslie  

Well, this is not possible at all, right?

Leslie

> I would like to do some selection on the remote side and then join the
> rest of the tables
> locally.  How is a query executed when it contains a mix of local and
> remote database tables?
You can´t mix local and remote databases.

One solution to this could be transfer local to remote or remote to local
and execute the selection in the appropriate place.

Eduardo

Eduardo

You mean something like this?  

insert into LocalDB.SomeClients
 Select * from RemoteDB.AllClients
    where [filter condition];

Select * from  LocalDB.SomeClients
 Join LocalDB. ....


Leslie

Leslie


I don't think that will work. I may be wrong but I don't think you're allowed to cross session boundaries. What about using the replication features? If not you'll have to (I think) generate a temporary table on the server side, stream that across to the local machine and proceed from there.

Roy Lambert [Team Elevate]

Leslie,

<< I would like to do some selection on the remote side and then join the
rest of the tables locally.  How is a query executed when it contains a mix
of local and remote database tables? >>

It isn't.  As Roy indicated, you can't cross session boundaries within a
single query.

The alternative is to stream the result set to a local table (can be a
temporary table) using SaveToStream/LoadFromStream, and then issue the query
locally.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim & Roy,

Thank you!

Leslie