Re: LEFT OUTER JOIN issue

<font face="Calibri" size="2">Hi,</font><br /><font face="Calibri" size="2">> SELECT
ct.dat,ct.heur,hp.datmesure,hp.heuremesure,hp.tFROM calendar_temp as ct</font><br /><font face="Calibri" size="2">>
LEFTOUTER JOIN h_part as hp</font><br /><font face="Calibri" size="2">> ON ct.dat = hp.datmesure</font><br /><font
face="Calibri"size="2">> AND ct.heur = hp.heuremesure</font><br /><font face="Calibri" size="2">> WHERE</font><br
/><fontface="Calibri" size="2">> hp.poste_idposte = 275</font><br /><font face="Calibri" size="2">> ORDER BY
ct.dat,ct.heur</font><br /><font face="Calibri" size="2"> </font><br /><font face="Calibri" size="2">> dat          
             heur      datmesure         heuremesure   t</font><br /><font face="Calibri" size="2">>
-----------------------------------------------------------</font><br/><font face="Calibri" size="2">> 15/03/2008  
     0:00       15/03/2008         0:00                       8,3</font><br /><font face="Calibri" size="2">>
15/03/2008        3:00       15/03/2008         3:00                       12</font><br /><font face="Calibri"
size="2">>15/03/2008         6:00       15/03/2008         6:00                       15</font><br /><font
face="Calibri"size="2">> 15/03/2008         9:00       15/03/2008         9:00                       18</font><br
/><fontface="Calibri" size="2">> 15/03/2008         12:00     null                        null                      
 null</font><br/><font face="Calibri" size="2">> 15/03/2008         15:00     null                        null      
                null</font><br /><br /><font face="Calibri" size="2">Would this work?</font><br /><font face="Calibri"
size="2">SELECTct.dat,ct.heur,hp.datmesure,hp.heuremesure,hp.t FROM calendar_temp as ct</font><br /><font
face="Calibri"size="2">LEFT OUTER JOIN h_part as hp</font><br /><font face="Calibri" size="2">ON ct.dat =
hp.datmesure</font><br/><font face="Calibri" size="2">AND ct.heur = hp.heuremesure</font><br /><font face="Calibri"
size="2">WHERE</font><br/><font face="Calibri" size="2">coalesce(hp.poste_idposte,275) = 275</font><br /><font
face="Calibri"size="2">ORDER BY ct.dat, ct.heur</font><br /><br /><font face="Calibri" size="2">    dat     |   heur  
|datmesure  | heuremesure |  t</font><br /><font face="Calibri"
size="2">------------+----------+------------+-------------+------</font><br/><font face="Calibri" size="2"> 2008-03-15
|00:00:00 | 2008-03-15 | 00:00:00    |  8.3</font><br /><font face="Calibri" size="2"> 2008-03-15 | 03:00:00 |
2008-03-15| 03:00:00    | 12.0</font><br /><font face="Calibri" size="2"> 2008-03-15 | 06:00:00 | 2008-03-15 | 06:00:00
  | 15.0</font><br /><font face="Calibri" size="2"> 2008-03-15 | 09:00:00 | 2008-03-15 | 09:00:00    | 18.0</font><br
/><fontface="Calibri" size="2"> 2008-03-15 | 12:00:00 |            |             |</font><br /><font face="Calibri"
size="2"> 2008-03-15| 15:00:00 |            |             |</font><br /><font face="Calibri" size="2">(6
rows)</font><br/><br /><font face="Calibri" size="2">Regards,</font><br /><font face="Calibri"
size="2">Jayadevan</font><fontface="sans-serif" size="2"><br /></font><br /><font face="sans-serif" size="2"><br /><br
/><br/><br /> DISCLAIMER:</font><font size="3"> </font><font color="#a2a2a2" face="Tahoma" size="1"><br /><br /> "The
informationin this e-mail and any attachment is intended only for the person to whom it is addressed and may contain
confidentialand/or privileged material. If you have received this e-mail in error, kindly contact the sender and
destroyall copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the
accuracy,adequacy or completeness of the information contained in this email or any attachment and is not liable for
anyerrors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."</font><font
size="3"><br/></font><font size="1"><br /></font><font size="3"><br /></font><br /><br />