한국지방행정연구원

SELECT a.* , (SELECT name FROM best_cate WHERE idx = a.cate1) AS cate1_name , (SELECT name FROM best_cate WHERE idx = a.cate2) AS cate2_name , (SELECT name FROM best_province WHERE idx = a.province) AS province_name , (SELECT code FROM best_province WHERE idx = a.province) AS province_code , (SELECT name FROM best_city WHERE idx = a.city) AS city_name , (SELECT code FROM best_city WHERE idx = a.city) AS city_code FROM best a WHERE a.idx = '2165'