SELECT album_id,title,main_img_path,sorc,area,theme,dfrom,dto,post_date,puser ,case when length(area) = 3 then (select distinct houmen_name from City_Master where city_cd = area) when length(area) = 2 then (select distinct houmen_name from City_Master where houmen_cd = area) end houmen_name ,case when length(area) = 3 then (select distinct houmeng_name from City_Master where city_cd = area) when length(area) = 2 then (select distinct houmeng_name from City_Master where houmen_cd = area) end houmeng_name FROM Dialy_Master WHERE area !='' AND theme !='' AND main_img_path != '' AND keisai_flg = 1 AND sorc = 2  AND contest_flg = 1 Order by houmeng_name, houmen_name82DB Error: unknown error