From oracle-l-bounce@freelists.org Thu Jan 27 01:31:16 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0R7VGpl012480 for ; Thu, 27 Jan 2005 01:31:16 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0R7VGem012476 for ; Thu, 27 Jan 2005 01:31:16 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E93664EC4; Thu, 27 Jan 2005 01:30:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21463-06; Thu, 27 Jan 2005 01:30:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2281464E9F; Thu, 27 Jan 2005 01:30:28 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=y0qbhRFhBnao+IPdI9Tt+eJTabyLrclE9FWiW3wZa/4CATP2p755IsFcu7JzTZHzLKMCrvHr9j769j42D+7u4NkWpme4AMCPNdXG3kgl5un8WFyICHp1ED/Us+2HWkTRwiYCOj9Zw3LPFQbqQJ77gt+hJ5KYNdQH8zVbenn6R94= ; Message-ID: <20050127062847.76053.qmail@web52904.mail.yahoo.com> Date: Wed, 26 Jan 2005 22:28:47 -0800 (PST) From: Kean Jacinta Subject: Re: Query Medical Claim To: sarath kumar , oracle-l@freelists.org In-Reply-To: <20050127043514.89354.qmail@web51408.mail.yahoo.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 15309 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jacintakean@yahoo.com Precedence: normal Reply-To: jacintakean@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.5 required=5.0 tests=FORGED_YAHOO_RCVD autolearn=no version=2.60 X-Spam-Level: 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 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 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