<!-- wp:html --> SET ROWCOUNT 0 SELECT EXIMDSTPG.ADDEXPENSE,EXIMDSTPG.ADDEXPENSEUFRS,EXIMINFO.EXIMFILECODE FROM LG_108_01_EXIMDISTPEG EXIMDSTPG WITH(NOLOCK) LEFT OUTER JOIN LG_108_01_INVEXIMINFO EXIMINFO WITH(NOLOCK) ON (EXIMDSTPG.EXIMINFOREF = EXIMINFO.LOGICALREF) LEFT OUTER JOIN LG_108_01_EXIMDISTLN EXIMDSTLN WITH(NOLOCK) ON (EXIMDSTPG.EXIMDISTLNREF = EXIMDSTLN.LOGICALREF) LEFT OUTER JOIN LG_108_01_STLINE STRNS WITH(NOLOCK) ON (EXIMDSTLN.SRVTRANSREF = STRNS.LOGICALREF) LEFT OUTER JOIN LG_108_ITEMS ITMSC WITH(NOLOCK) ON (EXIMDSTPG.ITEMREF = ITMSC.LOGICALREF) LEFT OUTER JOIN LG_108_SRVCARD SERVC WITH(NOLOCK) ON (EXIMDSTLN.SRVREF = SERVC.LOGICALREF) LEFT OUTER JOIN LG_108_01_INVOICE INVFC WITH(NOLOCK) ON (STRNS.INVOICEREF = INVFC.LOGICALREF) LEFT OUTER JOIN LG_108_CLCARD CLNTC WITH(NOLOCK) ON (INVFC.CLIENTREF = CLNTC.LOGICALREF) LEFT OUTER JOIN LG_108_01_INVOICE SRVINVFC WITH(NOLOCK) ON (EXIMINFO.INVOICEREF = SRVINVFC.LOGICALREF) LEFT OUTER JOIN LG_108_01_CLFLINE CTRNS WITH(NOLOCK) ON (EXIMDSTLN.SRVTRANSREF = CTRNS.LOGICALREF) LEFT OUTER JOIN LG_108_01_CLFICHE CLFIC WITH(NOLOCK) ON (CTRNS.SOURCEFREF = CLFIC.LOGICALREF) LEFT OUTER JOIN LG_108_CLCARD CLNTC_1 WITH(NOLOCK) ON (CTRNS.CLIENTREF = CLNTC_1.LOGICALREF) LEFT OUTER JOIN LG_108_01_EXIMDISTFC EXIMDSTFC WITH(NOLOCK) ON (EXIMDSTLN.EXIMDISTFCREF = EXIMDSTFC.LOGICALREF) LEFT OUTER JOIN LG_108_UNITSETF UNITSET WITH(NOLOCK) ON (STRNS.USREF = UNITSET.LOGICALREF) WHERE (EXIMINFO.EXIMFILECODE LIKE '2018.11') ORDER BY EXIMINFO.EXIMFILECODE, ITMSC.CODE, EXIMDSTLN.FICHETYPE, INVFC.FICHENO, CLFIC.FICHENO, STRNS.LOGICALREF, EXIMINFO.FILELINENR <!-- /wp:html -->