Passthrough Query help

[stukanewss]

I have the following passthrough:

SELECT
S_EVT_ACT."ROW_ID",
S_EVT_ACT."SRC_ID",
01BaseSRC_ID.SamplingSourceCode,
FROM
"SIEBEL"."S_EVT_ACT" S_EVT_ACT,
01BaseSRC_ID
WHERE
S_EVT_ACT."SRC_ID" = 01BaseSRC_ID."ROW_ID"

The data from s_evt_act is on an Oracle server. The data from 01BaseSRC_ID is a local table on my access db.

I have tried every syntax iteration I can think of but I can not get the query to work. Is it even possible to link data from an ODBC source with a local table in a passthrough query?

Thanks!

 

[PHV]

Is it even possible to link data from an ODBC source with a local table in a passthrough query?
I don't think so.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JonFer]

How many records are in each table?

John

http://www.interautomateconsulting.com