asasas

SELECT product_brand_code AS id, description AS text, cost_center_code AS cost_center, budget_division_code AS budget_division
FROM ap_product_brand WHERE  budget_division_code in (select budget_division_code from ap_budget_division where status = 1)