Re: SQL*Plus reporting question

From: - <Ardiels_at_umfolozi.ntech.ac.za>
Date: 1996/06/21
Message-ID: <4qdspf$4lh_at_Raven.und.ac.za>#1/1

 

> Hi Jeff,

Here is another approach:

   select t1.emp_no,

          emp_name,
          emp_dept,
          sum(work_reg_hours),
          sum(work_to_hours)
     from emp     t1,
          emp_hrs t2

    where t1.emp_no = t2.emp_no
   group by t1.emp_no,

            emp_name,
            emp_dept; 

From Ardiel (South Africa) Received on Fri Jun 21 1996 - 00:00:00 CEST