Hi I have a problem forming a query

I have 3 tables salary(hrs, clock_in , clock_out)

Break ( date, employe_id, net_time, break_in, break_out)

Employee(employee_id, pay_rate, name)

 

I need to get an hourly report till the current time for that day stating name, hour, no of hours, salary

Example

 

Rob      3-4        48min   $6.56

Min       2-3        23min   $2.34

Min       3-4        54min   $7.67

 

And so on….Would appreciate help on this…since I cant come up with the query

 

Vj

Reply via email to