SELECT
cus.customer_id AS 顧客ID
,CONCAT(
'〒'
,cus.zip01
,'-'
,cus.zip02
) AS 郵便番号
,zip.name AS 都道府県
,cus.addr01 AS 住所01
,cus.addr02 AS 住所02
,cus.birth AS 誕生日
FROM
dtb_customer AS cus
,mtb_pref AS zip
WHERE
cus.site_id = 1
AND cus.site_id = zip.site_id
AND cus.pref = zip.id
;