X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=69feee5fbb8b2bd5fea6ce23a9ed8a7181b662bb;hb=31469aea45d88c39de230035454e607cb926ccb1;hp=1d440c94aee5d1346f7833aa4c804f7ccf6b1cd9;hpb=d6ccc05f1d97979ee67c33451fdfd9cf5f124bb9;p=fa-stable.git

diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php
index 1d440c94..69feee5f 100644
--- a/sales/inquiry/customer_inquiry.php
+++ b/sales/inquiry/customer_inquiry.php
@@ -135,7 +135,7 @@ function get_transactions()
    	}
 
     $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date DESC, 
-	  debtor_trans.type,debtor_trans.trans_no ";
+	  ".TB_PREF."debtor_trans.type,".TB_PREF."debtor_trans.trans_no ";
 
     return db_query($sql,"No transactions were returned");
 }