- $sql = "SELECT ".TB_PREF."stock_master.*,".TB_PREF."item_tax_types.name AS tax_type_name
- FROM ".TB_PREF."stock_master,".TB_PREF."item_tax_types
- WHERE ".TB_PREF."item_tax_types.id=".TB_PREF."stock_master.tax_type_id
+ $sql = "SELECT item.*, taxtype.name AS tax_type_name
+ FROM ".TB_PREF."stock_master item,"
+ .TB_PREF."item_tax_types taxtype
+ WHERE taxtype.id=item.tax_type_id