把以下的sqlserver sql代码格式化:SELECT InvoiceAccount InvoiceAmountMST SumTax CurrencyCode RecId FROM CustInvoiceJourCustInvoiceJour_1 ORDER BY CustInvoiceJourInvoiceAccount ASC CustInvoiceJourInvoiceId ASC Cu
SELECT InvoiceAccount, InvoiceAmountMST, SumTax, CurrencyCode, RecId FROM CustInvoiceJour (CustInvoiceJour_1) JOIN MtxReceiptDateConfirmed FROM CustInvoiceTrans (CustInvoiceTrans_1) ON CustInvoiceJour.RecId = CustInvoiceTrans.ParentRecId JOIN PaymTermId, MtxBillOutputClass FROM CustTable (CustTable_1) ON CustInvoiceJour.InvoiceAccount = CustTable.AccountNum JOIN CustInvoiceJour_W (CustInvoiceJour_W_1) WHERE CustInvoiceJour.RecId = CustInvoiceJour_W.CustInvoiceJour AND RefNum = 0 AND InvoiceAccount = N'B0004' AND MtxReceiptDateConfirmed >= {ts '2023-01-24 00:00:00.000'} AND MtxReceiptDateConfirmed <= {ts '2023-01-24 00:00:00.000'} AND ConsDay_JP = 31 AND CustConsInvoice_JP = 0 ORDER BY CustInvoiceJour.InvoiceAccount ASC, CustInvoiceJour.InvoiceId ASC, CustInvoiceJour.RecId AS
原文地址: https://www.cveoy.top/t/topic/iMTs 著作权归作者所有。请勿转载和采集!