[에러]Every derived table must have its own alias
SELECT COUNT(*) FROM ( SELECT category_id, depth, top_category_id AS path, ctg_kor AS category_name, "series" AS category_type, ctg_kor AS scategory_name FROM tb_ncc_category WHERE service_enable = 'Y' UNION SELECT category_id, depth, full_category_path AS path, category_name, "subject" AS category_type, category_name AS scategory_name FROM tb_ncc_new_category WHERE service_enable = 'Y' ); 쿼리를 날..
2021. 1. 19.