Re: Query Medical Claim
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: sarath kumar <sarath_kumar0@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 Jan 2005 22:28:47 -0800 (PST)
Hi ,
I am so sorry , i didn't phrase my question properly.
I want to generate this report showing :
EmpNo MEdical Type Entitlement Used Balance
----------------------------------------------------
001 Sup - Medical 5000 1000 4000
001 Sup - Optical 300 100 200
Here are the existing table :
TBL_EMPMEDICAL
----------------
company_id employee_id med_id amount
C001 001 suvmed 98.00
C001 001 suvmed 700.00
C001 001 submed 222.00
C001 001 subopt 90.00
C001 001 subopt 11.00
...
TBL_MEDICAL_TYPES
------------------
med_id med_name entitlement
suvmed Suv-Medical 5000
subopt Sup-Optical 300
Can you pls help me .
Thank You
JK
--- sarath kumar <sarath_kumar0@xxxxxxxxx> wrote:
> 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
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
