create view `v_hjcd`
 AS select
 `tcd_houjin`.`法人CD` AS `法人CD`
,`tcd_houjin`.`法人名称` AS `法人名称`
,`tcd_houjin`.`法人カナ` AS `法人カナ`
,`tcd_houjin`.`法人郵便` AS `法人郵便`
,`tcd_houjin`.`法人住所` AS `法人住所`
,`tcd_houjin`.`代表者肩書` AS `代表者肩書`
,`tcd_houjin`.`代表者氏名` AS `代表者氏名`
,`tcd_houjin`.`代表者カナ` AS `代表者カナ`
,`tcd_houjin`.`法人本拠` AS `法人本拠`
,`tcd_houjin`.`法人電話` AS `法人電話`
,`tcd_houjin`.`法人FAX` AS `法人FAX`
,`tcd_houjin`.`連絡先メール` AS `連絡先メール`
,`tcd_houjin`.`連絡先電話` AS `連絡先電話`
,`tcd_houjin`.`連絡先携帯` AS `連絡先携帯`
,`tcd_houjin`.`法人備考` AS `法人備考`
,`tcd_houjin`.`廃業CD` AS `廃業CD`
,`tcd_houjin`.`法人個人` AS `法人個人`
,`tcd_jigyousho`.`事業所CD` AS `事業所CD`
,`tcd_jigyousho`.`事業所名称` AS `事業所名称`
,`tcd_jigyousho`.`事業所郵便` AS `事業所郵便`
,`tcd_jigyousho`.`事業所住所` AS `事業所住所`
,`tcd_jigyousho`.`事業所電話` AS `事業所電話`
,`tcd_jigyousho`.`事業所備考` AS `事業所備考`
,`tcd_jigyousho`.`事業所カナ` AS `事業所カナ`
 from (`tcd_houjin` join `tcd_jigyousho`
 on((`tcd_houjin`.`法人CD` = `tcd_jigyousho`.`法人CD`)))

