- $sql = "SELECT ".TB_PREF."debtors_master.debtor_no, name, curr_code FROM ".TB_PREF."debtors_master
- INNER JOIN ".TB_PREF."cust_branch
- ON ".TB_PREF."debtors_master.debtor_no=".TB_PREF."cust_branch.debtor_no
- INNER JOIN ".TB_PREF."areas
- ON ".TB_PREF."cust_branch.area = ".TB_PREF."areas.area_code
- INNER JOIN ".TB_PREF."salesman
- ON ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code";
+ $sql = "SELECT d.debtor_no, name, curr_code, d.inactive FROM ".TB_PREF."debtors_master d
+ INNER JOIN ".TB_PREF."cust_branch b
+ ON d.debtor_no=b.debtor_no
+ INNER JOIN ".TB_PREF."areas a
+ ON b.area = a.area_code
+ INNER JOIN ".TB_PREF."salesman s
+ ON b.salesman=s.salesman_code";