Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL

Re: SQL

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: Fri, 19 Jun 1998 15:14:59 -0500
Message-ID: <6meh2q$12v$1@news.ses.cio.eds.com>


SELECT fund, SUM(ACTUAL_HRS)

        FROM labor_to_date
UNUION ALL
SELECT fund, SUM(hours)

        FROM timecard
        WHERE timecard.month = 6

GROUP BY fund;

should work ... Received on Fri Jun 19 1998 - 15:14:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US