Fixed ambigous sql.

diff --git a/inventory/manage/item_categories.php b/inventory/manage/item_categories.php
index 78c21944d49f1a7c824d87eab58b749b758567d8..59873122551631accb12c39ba7adb6cfbb4903c4 100644 (file)
--- a/inventory/manage/item_categories.php
+++ b/inventory/manage/item_categories.php
@@ -95,7 +95,7 @@ if (list_updated('mb_flag')) {
 
 $sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, "
        .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id";
-if (!check_value('show_inactive')) $sql .= " AND !inactive";
+if (!check_value('show_inactive')) $sql .= " AND !c.inactive";
 
 $result = db_query($sql, "could not get stock categories");