Re: Query Medical Claim

  • From: sarath kumar <sarath_kumar0@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 26 Jan 2005 20:35:14 -0800 (PST)

select emp_name,emp_id,med_id,medical_type,
entitlement,amountused,entitlement-amountused balance
from
tbl_empmedical,tbl_medical_types where
tbl_empmedical.med_id = tbl_medical_types.med_id;


--- Kean Jacinta <jacintakean@xxxxxxxxx> wrote:

> Hi,
> 
> I need some help here. I wanted to generate a report
> 
> showing : emp_name, emp_id, med_id, medical_type,
> entitlement, used, balance.
> 
> TBL_EMPMEDICAL
> emp_code, 
> emp_id, 
> med_id,
> amountused
>  
> TBL_MEDICAL_TYPES
> 
> Med_ID  MediType      Entitlement
> ------------------------------------          
> M01     supmed        unlimited
> M02     execmed           5000
> M0      execmedopt        8000  
> 
> Each type of medical type have max amount of
> entitlement
> 
> I really need to solved this quick. Can someone help
> me out with this.
> 
> Your help is very much appreciated
> Thank You
> 
> JK 
> 
> 
> 
>               
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Mail - Easier than ever with enhanced search.
> Learn more.
> http://info.mail.yahoo.com/mail_250
> --
> //www.freelists.org/webpage/oracle-l
> 



                
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 
--
//www.freelists.org/webpage/oracle-l

Other related posts: