[RESOLVED] multiplying and adding problem

[alighouston]

hi all,
i am having problem with the following code how can i multiply hour and rate in the following query then add the values then following query works fine to retrieve the data and link it any ideas

Select sum(hours.employ_hours)as hour
,hours.employ_name,empoly.employ_pay as rate
 from hours left join empoly
on hours.employ_name=empoly.employ_name
group by employ_name

[alighouston]

think i got it working now next step is to divide it with certain value any ideas

Select hours.employ_name,sum(hours.employ_hours)* empoly.employ_pay
 from hours left join empoly on 
hours.employ_name=empoly.employ_name 
 group by employ_name with rollup 

[alighouston]

finally got it working here is the last code

select sum(total)/100 as total1 from
(Select hours.employ_name,sum(hours.employ_hours)* 
empoly.employ_pay as total from hours left join empoly on hours.employ_name=empoly.employ_name   

group by employ_name)as total1 

have fun hope it helps every one took me some time to finally figure it out

[christillis]

Thanks for posting your problem, and then how you got round the problem. Much appreciated.