Expand|Select|Wrap|Line Numbers
- ############ old query ################
- SELECT
- JU_STJS.SEDAI AS SEDAI,
- JU_STJS.KATA AS KATA,
- JU_STJS.USRNAM AS USRNAM,
- JU_STJS.SUU AS SUU,
- SYU.KATACD AS M_KATACD,
- SYU.HONTAICD AS M_HONTAICD,
- JU_STJS.SYRKBN AS SYRKBN,
- JU_STJS.KNMONEY AS KNMONEY,
- JU_STJS.KKMONEY AS KKMONEY,
- JU_STJS.KNKKMONEY AS KNKKMONEY,
- JU_STJS.RIYOU AS RIYOU,
- JU_STJS.MONEYKBN AS MONEYKBN,
- JU_STJS.KZ AS KZ,
- JU_STJS.UPDYMD AS UPDYMD,
- SYU.SYRKBN AS M_SYRKBN,
- SYU.BHNKBN AS M_BHNKBN,
- SYU.SEQ AS M_SEQ,
- SYU.KOUSUU AS M_KOUSUU,
- SYU.MSTITLE AS M_MSTITLE
- FROM
- MSYUKEI SYU ,
- (SELECT
- JU.SEDAI AS SEDAI,
- JU.KATA AS KATA,
- JU.USRNAM AS USRNAM,
- JU.SUU AS SUU,
- JU.KATACD AS KATACD,
- STJS.KNMONEY AS KNMONEY,
- STJS.KKMONEY AS KKMONEY,
- STJS.KNKKMONEY AS KNKKMONEY,
- STJS.RIYOU AS RIYOU,
- STJS.MONEYKBN AS MONEYKBN,
- STJS.HONTAICD AS HONTAICD,
- STJS.SYRKBN AS SYRKBN,
- STJS.GENKAKBN AS GENKAKBN,
- STJS.UPDYMD AS UPDYMD,
- JU.KZ AS KZ
- FROM
- GYDSTJS STJS,
- GY受注明細書 JU
- WHERE
- JU.SEIBAN = '46705' AND
- JU.SEIBAN + JU.SEDAI *= STJS.SEIBAN + STJS.SEDAI
- ) JU_STJS
- WHERE
- SYU.KATACD = JU_STJS.KATACD AND
- SYU.HONTAICD *= JU_STJS.HONTAICD AND
- SYU.SYRKBN *= JU_STJS.SYRKBN AND
- ((JU_STJS.GENKAKBN ='1' AND JU_STJS.SYRKBN ='1') OR
- JU_STJS.SYRKBN ='0')
Expand|Select|Wrap|Line Numbers
- SELECT
- JU_STJS.SEDAI AS SEDAI,
- JU_STJS.KATA AS KATA,
- JU_STJS.USRNAM AS USRNAM,
- JU_STJS.SUU AS SUU,
- SYU.KATACD AS M_KATACD,
- SYU.HONTAICD AS M_HONTAICD,
- JU_STJS.SYRKBN AS SYRKBN,
- JU_STJS.KNMONEY AS KNMONEY,
- JU_STJS.KKMONEY AS KKMONEY,
- JU_STJS.KNKKMONEY AS KNKKMONEY,
- JU_STJS.RIYOU AS RIYOU,
- JU_STJS.MONEYKBN AS MONEYKBN,
- JU_STJS.KZ AS KZ,
- JU_STJS.UPDYMD AS UPDYMD,
- SYU.SYRKBN AS M_SYRKBN,
- SYU.BHNKBN AS M_BHNKBN,
- SYU.SEQ AS M_SEQ,
- SYU.KOUSUU AS M_KOUSUU,
- SYU.MSTITLE AS M_MSTITLE
- FROM
- MSYUKEI SYU LEFT OUTER JOIN
- (SELECT
- JU.SEDAI AS SEDAI,
- JU.KATA AS KATA,
- JU.USRNAM AS USRNAM,
- JU.SUU AS SUU,
- JU.KATACD AS KATACD,
- STJS.KNMONEY AS KNMONEY,
- STJS.KKMONEY AS KKMONEY,
- STJS.KNKKMONEY AS KNKKMONEY,
- STJS.RIYOU AS RIYOU,
- STJS.MONEYKBN AS MONEYKBN,
- STJS.HONTAICD AS HONTAICD,
- STJS.SYRKBN AS SYRKBN,
- STJS.GENKAKBN AS GENKAKBN,
- STJS.UPDYMD AS UPDYMD,
- JU.KZ AS KZ
- FROM
- GY受注明細書 JU LEFT OUTER JOIN GYDSTJS STJS
- on JU.SEIBAN + JU.SEDAI = STJS.SEIBAN + STJS.SEDAI
- WHERE
- JU.SEIBAN = '46705'
- ) JU_STJS ON SYU.HONTAICD = JU_STJS.HONTAICD AND
- SYU.SYRKBN = JU_STJS.SYRKBN
- WHERE
- SYU.KATACD = JU_STJS.KATACD AND
- ((JU_STJS.GENKAKBN ='1' AND JU_STJS.SYRKBN ='1') OR
- JU_STJS.SYRKBN ='0')
I really don't know what to do with this.
i've been searching the solution for this for almost 2 weeks now. T_T