> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Brandon Metcalf
> Sent: Friday, July 10, 2009 12:16 PM
Change it to this:
> SELECT t.name AS machine_type_name,
> j.workorder,
> round(sum(EXTRACT(epoch FROM(j.clockout-
> j.clockin))/3600/w.quantity_made)::numeric,2)
> AS avgtime
> NULL AS employees
> FROM jobclock j
> JOIN employee e ON e.employee_id=j.employee_id
> JOIN machine m ON m.machine_id=j.machine_id
> JOIN machine_type t ON t.machine_type_id=m.machine_type_id
> JOIN workorder w ON w.workorder=j.workorder
> JOIN part p ON p.part_id=w.part_id
> WHERE p.part_id=379
> UNION
> SELECT t.name AS machine_type_name,
> NULL AS workorder,
> h.time AS avgtime,
> employees
> FROM part_time_historical h
> JOIN machine_type t ON
> t.machine_type_id=h.machine_type_id
> WHERE h.part_id=379 AND h.machine_type_id=1
> WHERE t.machine_type_id=1
> GROUP BY t.name,j.workorder
> ORDER BY avgtime
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital.now.
