Re: LEFT OUTER JOIN issue - Mailing list pgsql-sql
From | Jayadevan M |
---|---|
Subject | Re: LEFT OUTER JOIN issue |
Date | |
Msg-id | OF94932B74.C13D8741-ON6525770D.00141E18-6525770D.001445D5@ibsplc.com Whole thread Raw |
In response to | LEFT OUTER JOIN issue (Thomas BOURIMECH <thomas.bourimech@metnext.com>) |
List | pgsql-sql |
<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 />