[Fmsystem-commits] [12434] sql

[Sigurd Nes]

Revision: 12434
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=12434
Author:   sigurdne
Date:     2014-12-10 21:44:30 +0000 (Wed, 10 Dec 2014)
Log Message:
-----------
sql

Modified Paths:
--------------
    trunk/property/inc/class.sotts.inc.php

Modified: trunk/property/inc/class.sotts.inc.php
===================================================================
--- trunk/property/inc/class.sotts.inc.php      2014-12-10 21:36:40 UTC (rev 
12433)
+++ trunk/property/inc/class.sotts.inc.php      2014-12-10 21:44:30 UTC (rev 
12434)
@@ -403,7 +403,7 @@
                                {
                                        $end_period     = date('Ym', $end_date);
                                        $start_period   = date('Ym', 
$start_date);
-                                       $date_join = " LEFT OUTER JOIN 
fm_tts_payments ON ( fm_tts_tickets.id=fm_tts_payments.ticket_id AND 
fm_tts_payments.period >= $start_period AND fm_tts_payments.period <= 
$end_period )";
+                                       $date_join = "JOIN fm_tts_payments ON ( 
fm_tts_tickets.id=fm_tts_payments.ticket_id AND fm_tts_payments.period >= 
$start_period AND fm_tts_payments.period <= $end_period )";
                                        $actual_cost_field = 
'SUM(fm_tts_payments.amount) AS actual_cost';
                                        $actual_cost_group_field = '';
                                }