A pass-through query cannot communicate with local tables.
The only possibility is to create a second query that joins the
pass-through
query to the local table(s).
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"sj" <sh_khan18@[EMAIL PROTECTED]
> wrote in message
news:0A3ED41F-CC71-453A-AD7A-49CAC5465AB1@[EMAIL PROTECTED]
> can some one help me to link oracle tables to local database table in
this
> pass through query?
>
> Pass through query with orcale tables only:-
>
> select
>
pch.claim_number,pm.provider_id,vm.vendor_id,mm.subscriber_id,pch.line_of_business
> from doris.profsvc_claim_header pch,doris.prov_master
> pm,doris.member_master
> mm,doris.vendor_master vm
> Where pch.seq_prov_id = pm.seq_prov_id
> and pch.seq_memb_id=mm.seq_memb_id
> and pch.seq_vend_id=vm.seq_vend_id
> and pch.date_received>='1-JAN-08'
> and pch.line_of_business IN('WCM','LMR')
>
>
> Local access table I want to link to the oracle tables.
>
> PRT_CLAIMS_RE****TING.Claim_Number
>
|
