select mem.*, post.*, mem.f_districtcode as f_districtcode, mem.f_district as f_district, mem.f_thid as f_thid from tbl_member mem, tbl_memberpost post
where mem.f_daesu='8' and post.f_daesu='8' and post.f_gubun='1'
and mem.f_code=post.f_code
and (post.f_postcode='11' or post.f_postcode='22' or post.f_postcode='33') and mem.f_name like '%%'
order by post.f_chairman, post.f_gubun, post.f_postcode asc, post.f_committee asc
select mem.*, post.*, mem.f_districtcode as f_districtcode, mem.f_district as f_district, mem.f_thid as f_thid from tbl_member mem, tbl_memberpost post
where mem.f_daesu='8' and post.f_daesu='8' and post.f_gubun='2'
and mem.f_code=post.f_code
and (post.f_postcode='11' or post.f_postcode='22' or post.f_postcode='33') and mem.f_name like '%%'
order by post.f_chairman, post.f_gubun, post.f_postcode asc, post.f_committee asc