From 0d15d46e4424d98568b59e98dda37ed4607d7f77 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 26 Apr 2009 16:10:29 +0000 Subject: [PATCH] Fixed ambigous sql. --- inventory/manage/item_categories.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inventory/manage/item_categories.php b/inventory/manage/item_categories.php index 78c21944..59873122 100644 --- 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"); -- 2.30.2