Message-Id: <3.0.6.32.20020104121000.00996cb0@pop6.sympatico.ca>
Date: Fri, 04 Jan 2002 12:10:00 -0500
To: pgsql-sql@postgresql.org
From: Frank Bax <fbax@sympatico.ca>
Subject: simple? join
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

EMPLOYEE table contains: emp, first, last (emp is unique key)
TIMESHEET table contains: emp, timestamp, hours

I want to report employee name and total hours.

So far, I've come up with:

SELECT min(emp.first) as first, min(emp.last) as last, sum(ts.hours)
  FROM timesheet ts, employee emp
 WHERE ts.emp = emp.emp
 GROUP by emp.emp
 ORDER BY last, first;

It seems silly to specify "min" when I know there is only one value per emp!

SELECT first, last, sum(ts.hours)
  FROM timesheet ts, employee emp
 WHERE ts.emp = emp.emp 
 GROUP by emp.emp, first, last
 ORDER BY last, first;

It seems silly to specify extraneous "group by" fields.

Is there a 'better' way to write this SQL?

Frank