- $sql = "SELECT ".TB_PREF."item_tax_types.* FROM ".TB_PREF."item_tax_types,".TB_PREF."stock_master WHERE
- ".TB_PREF."stock_master.stock_id=".db_escape($stock_id)."
- AND ".TB_PREF."item_tax_types.id=".TB_PREF."stock_master.tax_type_id";
-
+ $sql = "SELECT tax_type.*, item.vat_category
+ FROM ".TB_PREF."item_tax_types tax_type,"
+ .TB_PREF."stock_master item
+ WHERE
+ item.stock_id=".db_escape($stock_id)."
+ AND tax_type.id=item.tax_type_id";
+