Re: Query Medical Claim

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 26 Jan 2005 22:28:47 -0800 (PST)
Message-ID: <20050127062847.76053.qmail@web52904.mail.yahoo.com>

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_at_yahoo.com> 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_at_yahoo.com> 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
> > --
> > http://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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 27 2005 - 01:31:16 CST