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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 26 2005 - 23:37:44 CST
