sql query - Mailing list pgsql-sql

From Vijay Uppal
Subject sql query
Date
Msg-id 000001c29b39$5397e5a0$6501a8c0@bc.hsia.telus.net
Whole thread Raw
List pgsql-sql

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

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: SQL syntax for concating values in different rows together
Next
From: "mark carew"
Date:
Subject: Re: import sql script