Hi!

Is it possible to make a SQL query that retrieves data from two tables, one
local and one remote?

For example:

   select * "from c:\local_table.dat" inner join remote_table.db on ....

"Query.DataBaseName" and "Query.SessionName" are set to the Remote database,
but I get an error when trying to open the Query.

Santy Concepción wrote:
> Hi!
>
> Is it possible to make a SQL query that retrieves data from two
> tables, one local and one remote?

No.

Ralf

I need to make a query that needs to collect data from two tables. One of
them is in one computer, and the other one is in another computer.

With FileSharing there is no problem, but with C/S I get an error message
when opening the query.

What can I do?
Maybe using memory tables?

"Ralf Mimoun" <nospam@rad-on.de> escribió en el mensaje
news:FA18562D-6BB2-4169-A6FB-E81DFEF78AC9@news.elevatesoft.com...
> Santy Concepción wrote:
>> Hi!
>>
>> Is it possible to make a SQL query that retrieves data from two
>> tables, one local and one remote?
>
> No.
>
> Ralf

Santy

You need two Sessions, one remote other local.
Transfer local data to a remote table and then perform a join.
Remember memory tables in C/S are located at server memory.

Eduardo

Jose Eduardo Helminsky wrote:
> Santy
>
> You need two Sessions, one remote other local.
> Transfer local data to a remote table and then perform a join.

Or the other way around: load all in the client.

Ralf