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 |
- [SQL] sql query manjul katare
- [SQL] SQL Query Miguel González
- Re: [SQL] SQL Query Miguel González
- [SQL] SQL QUERY Pedro Igor
- Re: [SQL] SQL QUERY Achilleus Mantzios
- Re: [SQL] SQL QUERY Achilleus Mantzios
- Re: [SQL] sql query Vijay Uppal
- Re: [SQL] sql query Christoph Haller
- [SQL] SQL query Paul Czubilinski
- [SQL] SQL Query beyaNet Consultancy
- Re: [SQL] SQL Query Bruno Wolff III