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