Here is an example for Oracle join:
SELECT a.acct_num,
a.grp_num,
a.div_num,
a.sub_pers_num,
a.pat_pers_num,
a.pat_dob,
a.rel_code,
b.pat_pmt,
b.deductible_amt,
b.net_pmt
FROM source.master_claim a,
source.master_line b,
param.proc_hier c,
param.con_product d
WHERE a.clm_num = b.clm_num
AND a.clm_seq = b.clm_seq
AND a.clm_stat IN ( 'P', 'H', 'A' )
AND b.billed_ada_proc = c.proc_key
AND b.prod_id = d.prod_id
AND c.max_app = 'BASIC';
-------------------------------------------
And here is the equivalent ANSI join:
SELECT a.acct_num,
a.grp_num,
a.div_num,
a.sub_pers_num,
a.pat_pers_num,
a.pat_dob,
a.rel_code,
b.pat_pmt,
b.deductible_amt,
b.net_pmt
FROM source.master_claim a
join source.master_line b
ON ( a.clm_num = b.clm_num
AND a.clm_seq = b.clm_seq )
join param.proc_hier c
ON ( b.billed_ada_proc = c.proc_key )
join param.con_product d
ON ( b.prod_id = d.prod_id )
WHERE a.clm_stat IN ( 'P', 'H', 'A' )
AND c.max_app = 'BASIC';
-------------------------------------
Thanks in advance!
