create view `v_hjcd_short`
 AS select
 `tcd_houjin`.`法人CD` AS `法人CD`
,`tcd_houjin`.`法人名称` AS `法人名称`
,`tcd_houjin`.`法人カナ` AS `法人カナ`
,`tcd_jigyousho`.`事業所CD` AS `事業所CD`
,`tcd_jigyousho`.`事業所名称` AS `事業所名称`
 from (`tcd_houjin` join `tcd_jigyousho`
 on((`tcd_houjin`.`法人CD` = `tcd_jigyousho`.`法人CD`)))

