选择T0。[AcctCode]为'N°da Conta',T0。[AcctName]作为'Nome da conta',T0。[CurrTotal]作为'Saldo da conta',convert(varchar,T1。[RefDate], 105),如" Data delançamento",T1。[ContraAct]如" Conta de相反部分",T2。[Number]如"NºdoDiário",T1。[BaseRef]如"NºOrigem",T1。[Ref1] 来自OACT T0的内部参考JDT1 T1上的O. .BaseRef,其中AcctCode LIKE'691%'或ACCtcode LIKE'6228%'按T1顺序排列。[RefDate]
完成:)我进行了此查询
选择T0。[AcctCode]为'N°da Conta',T0。[AcctName]作为'Nome da conta',T0。[CurrTotal]作为'Saldo da conta',convert(varchar,T1。[RefDate], 105),如" Data delançamento",T1。[ContraAct]如" Conta de相反部分",T2。[Number]如"NºdoDiário",T1。[BaseRef]如"NºOrigem",T1。[Ref1] 来自OACT T0的内部参考JDT1 T1上的O. .BaseRef,其中AcctCode LIKE'691%'或ACCtcode LIKE'6228%'按T1顺序排列。[RefDate]
一周热门 更多>