$sql = "SELECT sorder.order_no, concat(sorder.$ref, '-', debtor.name) as IName
FROM ".TB_PREF."debtors_master debtor,"
.TB_PREF."sales_orders sorder
$sql = "SELECT sorder.order_no, concat(sorder.$ref, '-', debtor.name) as IName
FROM ".TB_PREF."debtors_master debtor,"
.TB_PREF."sales_orders sorder