Joining two linked tables in one query

[kviglas]

Hello,

This is my first thread in this forum and I hope to find some answers. I am trying to make a query from a linked table (PRODDTA_F0006) and a select query (F0911), but when I am running it, I am getting the following message:

ODBC - call failed

[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation (#1013)


I am using Windows 2000 with Office XP and the database is Oracle 8.0. Does anyone know something that can help?

SELECT 
F0911.GLAN8, 
PRODDTA_F0006.MCRP05, 
F0911.GLPN,
Count(F0911.Amount) AS CountOfAmount, 
Sum(F0911.Amount) AS SumOfAmount
FROM F0911 
INNER JOIN PRODDTA_F0006 ON F0911.GLMCU=PRODDTA_F0006.MCMCU
GROUP BY 
F0911.GLAN8, PRODDTA_F0006.MCRP05, F0911.GLPN;

 

[maxmangion]

try the following:

1. Change the timeout property to 0. (unlimited instead of 60 seconds by
default.)

2. Use a SQL Pass Through query instead.
You would use Oracle syntax in it and send it to the server where the whole
thing is processed and only the result are returned. The results are read
only though

 

[kviglas]

Thank you for your answer.

As for the timeout property, I had no result but the pass-through query seems to execute faster. Can I use the results of a pass-through query to other queries with the same velocity?