Global fixes in SQL queries aimed to make them more readible and easier for maintence.

[fa-stable.git] / reporting / rep205.php

diff --git a/reporting/rep205.php b/reporting/rep205.php
index d2f500b3957d5f2f85fa4c599ba443dc5d35f7b7..5de3fd4aa590c06720b3295374037e953d5b1e01 100644 (file)
--- a/reporting/rep205.php
+++ b/reporting/rep205.php
@@ -30,20 +30,11 @@ print_supplier_details_listing();
 
 function get_supplier_details_for_report()
 {
-       $sql = "SELECT ".TB_PREF."suppliers.supplier_id,
-                       ".TB_PREF."suppliers.supp_name,
-                       ".TB_PREF."suppliers.address,
-                       ".TB_PREF."suppliers.supp_address,
-                       ".TB_PREF."suppliers.supp_ref,
-                       ".TB_PREF."suppliers.contact,
-                       ".TB_PREF."suppliers.curr_code,
-                       ".TB_PREF."suppliers.dimension_id,
-                       ".TB_PREF."suppliers.dimension2_id,
-                       ".TB_PREF."suppliers.notes,
-                       ".TB_PREF."suppliers.gst_no
-               FROM ".TB_PREF."suppliers
-               WHERE inactive = 0
-               ORDER BY supp_name";
+       $sql = "SELECT supplier_id,     supp_name, address, supp_address, supp_ref,
+                               contact, curr_code,     dimension_id, dimension2_id, notes, gst_no
+                       FROM ".TB_PREF."suppliers
+                       WHERE inactive = 0
+                       ORDER BY supp_name";
 
     return db_query($sql,"No transactions were returned");
 }