実際のクエリからデータを取得してみると
下記になり、送り状ＮＯは、JOINされた「VKOMST2」の項目を使用している。＞＞＞ないのでNULL
SELECT
VKTSITK.VYOSSSNO AS DYOSSSNO -- 専門集配票ＮＯ
,VKSHUTA.TMJSDSNO AS DYOSDSNO -- 代表集配票ＮＯ
,VKSHUTA.TMJSAAID AS DYOSSYID -- 集配票ＩＤ
,VKSHUTA.TMJSYOSH AS DYOSITCD -- 委託会社コード
,VKSHUTA.TMJSKYMD AS DYOSKYMD -- 稼働年月日
,VKTSITK.VYOSKYTN AS DYOSTNCD -- 委託店所コード
,VKSHUTA.TMJSSHBN AS DYOSSYNO -- 社番か車号
,VKOMST2.VOKROKNO AS DYOSOKNO -- 送り状ＮＯ
,VKOMST2.VOKRKOSU -- 個数
,VKOMST2.VOKRKGRM -- 重量
,VKOMST2.VOKRCKCD -- 荷受人 着地コード
,VKOMST2.VOKRMWRT -- 割増 率
FROM
VKTSITK
INNER JOIN
VKSHUTA
ON
VKTSITK.VYOSSSNO = VKSHUTA.TMJSSKNO
AND VKTSITK.VYOSKYTN = VKSHUTA.TMJSKYTN
AND VKTSITK.VYOSSYHI = VKSHUTA.TMJSSYHI
LEFT JOIN
VKOMST2
ON
(CASE VKTSITK.VYOSSYHI WHEN CAST('1' AS NCHAR(1)) THEN VKOMST2.VOKRKONO ELSE VKOMST2.VOKRHSKO END) = VKTSITK.VYOSSSNO
WHERE
VKTSITK.VYOSSSNO = '87937695'
ORDER BY
VKTSITK.VYOSSSNO
,VKTSITK.VYOSKYTN
,VKTSITK.VYOSSYHI
| DYOSSSNO |
DYOSDSNO |
DYOSSYID |
DYOSITCD |
DYOSKYMD |
DYOSTNCD |
DYOSSYNO |
DYOSOKNO |
VOKRKOSU |
VOKRKGRM |
VOKRCKCD |
VOKRMWRT |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
| 87937695 |
72324011 |
25 |
1803156 |
20260301 |
1103 |
08110 |
(null) |
(null) |
(null) |
(null) |
(null) |
A＞＞＞送り状マスタNO2しか見ていないため上記のような動作になったようです。
PL/1ではDDPのみの照会（未確認）のため、ロジックは正しい？？
＞送り状マスタNO2しか見ていないがバグ(？)かと思います。
