问题已经解决SELECT PettycashHeader.CD_TEMPO ,Tempo.KJ_TEMPORYAKU ,PettycashSchou.NO_MEISAI ,PettycashSchou.YM_HASSEI ,Naiyou.KJ_NAIYOU ,PettycashSchou.KJ_KOTEITEKIYOU ,PettycashSchou.KJ_TEKIYOU ,PettycashSchou.KB_NYUUSHUKKIN ,PettycashSchou.MN_KINGAKU ,PettycashSchou.YM_HOUKOKU ,PettycashSchou.YM_SHOUNIN FROM D_PETTYCASHHEADER PettycashHeader LEFT OUTER JOIN M_TEMPO Tempo ON PettycashHeader.CD_TEMPO=Tempo.CD_TEMPO, D_PETTYCASHSCHOU PettycashSchou LEFT OUTER JOIN M_NAIYOU Naiyou ON PettycashSchou.CD_NAIYOU=Naiyou.CD_NAIYOU WHERE PettycashHeader.YM_HASSEINENGETU=PettycashSchou.YM_HASSEINENGETU AND PettycashHeader.CD_TEMPO=PettycashSchou.CD_TEMPO AND PettycashHeader.CD_TEMPO >=1 AND PettycashHeader.CD_TEMPO <=10 AND PettycashHeader.YM_HASSEINENGETU=200405 ORDER BY PettycashHeader.CD_TEMPO,PettycashSchou.NO_MEISAI即可谢谢!
,Tempo.KJ_TEMPORYAKU
,PettycashSchou.NO_MEISAI
,PettycashSchou.YM_HASSEI
,Naiyou.KJ_NAIYOU
,PettycashSchou.KJ_KOTEITEKIYOU
,PettycashSchou.KJ_TEKIYOU
,PettycashSchou.KB_NYUUSHUKKIN
,PettycashSchou.MN_KINGAKU
,PettycashSchou.YM_HOUKOKU
,PettycashSchou.YM_SHOUNIN
FROM D_PETTYCASHHEADER PettycashHeader
LEFT OUTER JOIN M_TEMPO Tempo
ON PettycashHeader.CD_TEMPO=Tempo.CD_TEMPO,
D_PETTYCASHSCHOU PettycashSchou
LEFT OUTER JOIN M_NAIYOU Naiyou
ON PettycashSchou.CD_NAIYOU=Naiyou.CD_NAIYOU
WHERE PettycashHeader.YM_HASSEINENGETU=PettycashSchou.YM_HASSEINENGETU
AND PettycashHeader.CD_TEMPO=PettycashSchou.CD_TEMPO
AND PettycashHeader.CD_TEMPO >=1
AND PettycashHeader.CD_TEMPO <=10
AND PettycashHeader.YM_HASSEINENGETU=200405
ORDER BY PettycashHeader.CD_TEMPO,PettycashSchou.NO_MEISAI即可谢谢!