From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | vijay25(at)telus(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: sql query |
Date: | 2002-12-11 09:06:39 |
Message-ID: | 3DF7001F.C8D3FD3C@rodos.fzk.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
How do you intend to find out which entry in your table "salary" is
related
to which employee as there is no id to refer to.
Am I right in assuming your column "hour" with entries 3-4, 2-3, ...
means from 3 til 4 o'clock and so on?
Regards, Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Haller | 2002-12-11 09:56:09 | Re: Question II |
Previous Message | Christoph Haller | 2002-12-11 08:57:12 | Re: Question |