Union sum() 1

[fordtran]

I am sorry, the search facility is down, but I need help now.

I have two tables named HOURS and OLDHOURS.
Each table has fields HOURSWORKED and HOURSOVERTIME

I need to summarise the hoursworked and the hoursovertime such as in :

Sum(HOURSWORKED)as TOTALHOURSWORKED and sum(HOURSOVERTIME) as TOTALHOURSOVERTIME from the union of tables HOURS and OLDHOURS.

Thanks


fordtran

 

[PHV]

A starting point:
SELECT Sum(hw) AS TOTALHOURSWORKED, Sum(ho) AS TOTALHOURSOVERTIME
FROM (
SELECT Sum(HOURSWORKED) AS hw, Sum(HOURSOVERTIME) AS ho FROM HOURS
UNION ALL SELECT Sum(HOURSWORKED), Sum(HOURSOVERTIME) FROM OLDHOURS
) AS U

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fordtran]

Have a star. Thanks

fordtran