sql query - Mailing list pgsql-sql

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