Re: Pass through query link oracle table to local access table
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Aug 2008 17:17:18 -0400
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@xxxxxxxxx> wrote in message
news:0A3ED41F-CC71-453A-AD7A-49CAC5465AB1@xxxxxxxxxxxxxxxx
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_REPORTING.Claim_Number
.
- Prev by Date: Re: Query won't accept 0
- Next by Date: Vista -Access 2000 2003
- Previous by thread: Re: Query won't accept 0
- Next by thread: Vista -Access 2000 2003
- Index(es):
Relevant Pages
|
Loading
