[orca-users:05231] Re: FileMakerへORCAからのデータインポートについて

["YUKITOMO AIBA" <aiba@xxxxxxxxxxxxx>]

お疲れ様です。饗庭です。
以下のSQL文をファイルメーカーPro6を使って試してみましたが、欠落しているよう
にはありませんでした。
保険情報の項目を追加しています。
欠番が生じたSQL文を具体的に示して頂ければ幸いです。

SELECT
"tbl_ptnum"."ptnum","tbl_ptinf"."kananame","tbl_ptinf"."name","tbl_ptinf"."b
irthday","tbl_ptinf"."sex",
"tbl_hkncombi"."hkncombinum","tbl_pthkninf"."tekedymd"
,"tbl_pthkninf"."hknnum","tbl_pthkninf"."hknjanum",
"tbl_pthkninf"."kigo","tbl_pthkninf"."num",
"tbl_hkncombi"."honkzkkbn","tbl_hkncombi"."gai_kftnrate",
"tbl_pthkninf"."skkgetymd","tbl_ptkohinf"."ftnjanum",
"tbl_ptkohinf"."ftnjanum","tbl_ptkohinf"."jkysnum",
"tbl_ptkohinf"."tekstymd","tbl_ptkohinf"."tekedymd",
"tbl_ptkohinf_1"."ftnjanum","tbl_ptkohinf_1"."ftnjanum",
"tbl_ptkohinf_1"."jkysnum","tbl_ptkohinf_1"."tekstymd",
"tbl_ptkohinf_1"."tekedymd","tbl_hknjainf"."hknjaname",
"tbl_hknjainf"."adrs",
"tbl_pthkninf"."hknid","tbl_pthkninf"."hojokbn","tbl_pthkninf"."contkbn","tb
l_pthkninf"."kakuninymd"
FROM (((((tbl_ptnum INNER JOIN tbl_ptinf ON tbl_ptnum.ptid = tbl_ptinf.ptid)
LEFT JOIN tbl_hkncombi ON tbl_ptinf.ptid = tbl_hkncombi.ptid) LEFT JOIN
tbl_pthkninf ON (tbl_hkncombi.hknid = tbl_pthkninf.hknid) AND
(tbl_hkncombi.ptid = tbl_pthkninf.ptid)) LEFT JOIN tbl_ptkohinf ON
(tbl_hkncombi.koh1id = tbl_ptkohinf.kohid) AND (tbl_hkncombi.ptid =
tbl_ptkohinf.ptid)) LEFT JOIN tbl_ptkohinf AS tbl_ptkohinf_1 ON
(tbl_hkncombi.ptid = tbl_ptkohinf_1.ptid) AND (tbl_hkncombi.koh2id =
tbl_ptkohinf_1.kohid)) LEFT JOIN tbl_hknjainf ON tbl_pthkninf.hknjanum =
tbl_hknjainf.hknjanum
WHERE (((tbl_hkncombi.hkncombinum)=1) AND
((tbl_pthkninf.tekedymd)>='20030401'));

饗庭幸友
株式会社ファティマ