Thread: sql query

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi I have a problem forming a query</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">I have 3 tables <span class="GramE">salary(</span>hrs, <span class="SpellE">clock_in</span> , <span
class="SpellE">clock_out</span>)</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Break <span class="GramE">( date</span>, <span class="SpellE">employe_id</span>, <span
class="SpellE">net_time</span>,<span class="SpellE">break_in</span>, <span
class="SpellE">break_out</span>)</span></font><pclass="MsoNormal"><span class="GramE"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Employee(</span></font></span><spanclass="SpellE"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family: 
Arial">employee_id</span></font></span><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">,
<spanclass="SpellE">pay_rate</span>, name)</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I need to get an hourly report till the current time for that day stating name, hour, no of hours,
salary</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Example</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Rob<span style="mso-tab-count:1">      </span>3-4<span style="mso-tab-count:1">       
</span>48min<spanstyle="mso-tab-count:1">   </span>$6.56</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">Min<span style="mso-tab-count:1">       </span>2-3<span style="mso-tab-count:1">       
</span>23min<spanstyle="mso-tab-count:1">   </span>$2.34</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">Min<span style="mso-tab-count:1">       </span>3-4<span style="mso-tab-count:1">       
</span>54min<spanstyle="mso-tab-count:1">   </span>$7.67</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">And so on….Would appreciate help on this…since I <span class="GramE">cant</span> come up with the
query</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Vj </span></font></div>

>
> 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