把以下的sqlserver sql代码格式化:SELECT T1INVOICEACCOUNTT1INVOICEAMOUNTMSTT1SUMTAXT1CURRENCYCODET1RECIDT2MTXRECEIPTDATECONFIRMEDT2RECIDT3PAYMTERMIDT3MTXBILLOUTPUTCLASST3RECID FROM CUSTINVOICEJOUR T1 CROSS JOIN
SELECT T1.INVOICEACCOUNT, T1.INVOICEAMOUNTMST, T1.SUMTAX, T1.CURRENCYCODE, T1.RECID, T2.MTXRECEIPTDATECONFIRMED, T2.RECID, T3.PAYMTERMID, T3.MTXBILLOUTPUTCLASS, T3.RECID FROM CUSTINVOICEJOUR T1 CROSS JOIN CUSTINVOICETRANS T2 CROSS JOIN CUSTTABLE T3 WHERE (((T1.PARTITION = 5637144576) AND (T1.DATAAREAID = N'mtx')) AND ((T1.REFNUM = ?) AND (T1.INVOICEACCOUNT = ?))) AND (((T2.PARTITION = 5637144576) AND (T2.DATAAREAID = N'mtx')) AND (((T2.MTXRECEIPTDATECONFIRMED >= ?) AND (T2.MTXRECEIPTDATECONFIRMED <= ?)) AND (T1.RECID = T2.PARENTRECID))) AND (((T3.PARTITION = 5637144576) AND (T3.DATAAREAID = N'mtx')) AND ((T3.CONSDAY_JP = ?) AND (T1.INVOICEACCOUNT = T3.ACCOUNTNUM))) AND EXISTS (SELECT 'x' FROM CUSTINVOICEJOUR_W T4 WHERE (((T4.PARTITION = 5637144576) AND (T4.DATAAREAID = N'mtx')) AND ((T4.CUSTCONSINVOICE_JP = ?) AND (T1.RECID = T4.CUSTINVOICEJOUR)))) ORDER BY T1.INVOICEACCOUNT, T1.INVOICEID, T1.RECI
原文地址: https://www.cveoy.top/t/topic/iMTp 著作权归作者所有。请勿转载和采集!