Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CF3C34761EA for ; Tue, 3 Dec 2002 21:04:29 -0500 (EST) Received: from priv-edtnes61.telusplanet.net (outbound01.telus.net [199.185.220.220]) by postgresql.org (Postfix) with ESMTP id E546F474E42 for ; Tue, 3 Dec 2002 21:04:28 -0500 (EST) Received: from laptop ([209.121.11.71]) by priv-edtnes61.telusplanet.net (InterMail vM.5.01.05.17 201-253-122-126-117-20021021) with ESMTP id <20021204020432.NOIW1559.priv-edtnes61.telusplanet.net@laptop> for ; Tue, 3 Dec 2002 19:04:32 -0700 From: "Vijay Uppal" To: Subject: sql query Date: Tue, 3 Dec 2002 18:03:22 -0800 Message-ID: <000001c29b39$5397e5a0$6501a8c0@bc.hsia.telus.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C29AF6.4574A5A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/113 X-Sequence-Number: 10701 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C29AF6.4574A5A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0001_01C29AF6.4574A5A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi I have a problem forming a query

I have 3 tables salary(hrs, <= span class=3DSpellE>clock_in , clock_out)

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

Employee(= employee_id, pay_rat= e, name)

 

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

Example

 

Rob   &nb= sp;  3-4        48min   $6.56<= /span>

Min   &nb= sp;   2-3        23min   $2.34<= /span>

Min   &nb= sp;   3-4        54min   $7.67<= /span>

 

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

 

Vj

------=_NextPart_000_0001_01C29AF6.4574A5A0--