SELECT
    m.name, z.sido, z.sigun, z.doro_name,
    z.building_main, z.building_sub
   FROM member m, zipcode z
WHERE m.address = z.building_manage;