CREATE VIEW vhoujinjigyousho AS SELECT tcdhoujin1532.法人CD, tcdhoujin1532.法人名称, tcdhoujin1532.法人カナ, tcdjigyousho1543.事業所CD, tcdjigyousho1543.事業所名称 FROM tcdhoujin1532 INNER JOIN tcdjigyousho1543 ON tcdhoujin1532.法人CD = tcdjigyousho1543.法人CD;
