X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fsupp_trans_db.inc;h=081e8580e62c2359a10ba69cc745998940a6ddd5;hb=91bede4226ba8b45151f0501ac88eb946ed5f2a1;hp=6af755e659c6c466e0e72b8f4ff22e977f8c7c79;hpb=1571869d54be48452fdbe08f25130972ff0a7b5a;p=fa-stable.git diff --git a/purchasing/includes/db/supp_trans_db.inc b/purchasing/includes/db/supp_trans_db.inc index 6af755e6..081e8580 100644 --- a/purchasing/includes/db/supp_trans_db.inc +++ b/purchasing/includes/db/supp_trans_db.inc @@ -214,7 +214,7 @@ function get_sql_for_supplier_inquiry($filter, $after_date, $to_date, $supplier_ $sql = $sql2; } elseif (!isset($filter) || $filter == ALL_TEXT || $filter == '6') { - $sql = "SELECT * FROM (($sql) UNION ($sql2)) as tr"; + $sql = "SELECT * FROM (($sql) UNION ($sql2)) as tr WHERE 1"; } if (isset($filter) && $filter != ALL_TEXT)