[Noalyss-commit] [noalyss] 32/151: Performance : improve VERIF

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit ee6d71f8bbc1eb22239d17c280afd0a444cbd42a
Author: Dany De Bontridder <address@hidden>
Date:   Fri Dec 2 23:33:25 2016 +0100

    Performance : improve VERIF
---
 include/verif_bilan.inc.php |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/verif_bilan.inc.php b/include/verif_bilan.inc.php
index 58827be..6d96cd6 100644
--- a/include/verif_bilan.inc.php
+++ b/include/verif_bilan.inc.php
@@ -107,7 +107,7 @@ echo '</div>';
             where
             source.j_id < target.j_id 
             and source.j_poste<>target.j_poste 
-            and source.j_qcode = target.j_qcode
+            and source.f_id = target.f_id
             and $sql_year_source and $sql_year_target
            ";
     $sql_poste="select distinct j_poste,pcm_lib from jrnx join tmp_pcmn on 
(pcm_val=j_poste) where j_qcode =$1 $sql_year";