delete #SP_GL_BAL_T
from #SP_GL_BAL_T T left join MA_COA_ACC A on A.COA_CODE=
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)
AND A.ACC_CODE=T.CODE1
where A.IS_CURR<>'Y' OR A.IS_CURR is NULL OR A.IS_QTY<>'Y' OR A.IS_QTY is NULLdelete #SP_GL_BAL_T
from #SP_GL_BAL_T
join #SP_GL_BAL_T A on #SP_GL_BAL_T.RECLEVEL=7 AND A.RECLEVEL=8
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9
AND A.CUR_CODE=#SP_GL_BAL_T.CUR_CODE
来是MS SQL语句,如何该成ORACLE的SQL
我用的是8i,多谢!
from #SP_GL_BAL_T T left join MA_COA_ACC A on A.COA_CODE=
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)
AND A.ACC_CODE=T.CODE1
where A.IS_CURR<>'Y' OR A.IS_CURR is NULL OR A.IS_QTY<>'Y' OR A.IS_QTY is NULLdelete #SP_GL_BAL_T
from #SP_GL_BAL_T
join #SP_GL_BAL_T A on #SP_GL_BAL_T.RECLEVEL=7 AND A.RECLEVEL=8
AND A.CODE1=#SP_GL_BAL_T.CODE1
AND A.CODE2=#SP_GL_BAL_T.CODE2
AND A.CODE3=#SP_GL_BAL_T.CODE3
AND A.CODE4=#SP_GL_BAL_T.CODE4
AND A.CODE5=#SP_GL_BAL_T.CODE5
AND A.CODE6=#SP_GL_BAL_T.CODE6
AND A.CODE7=#SP_GL_BAL_T.CODE7
AND A.CODE8=#SP_GL_BAL_T.CODE8
AND A.CODE9=#SP_GL_BAL_T.CODE9
AND A.CUR_CODE=#SP_GL_BAL_T.CUR_CODE
来是MS SQL语句,如何该成ORACLE的SQL
我用的是8i,多谢!
日期改为to_date()或是to_char()
还是自己看
http://gwynne.cs.ualberta.ca/~oracle/817doc/server.817/a82950/toc.htm