1 2 3 4
| SELECT SFETF1PDTA_PDEM.NSIREN, SFETF1PDTA_PDEM.CMTCCIAL, SFETF1PDTA_PDEM.CDORIG, SFETF1PDTA_PDEM.MTFINC, SFETF1PDTA_PDEM.DUFINC, SFETF1PDTA_PDEM.CDPAIE, SFETF1PDTA_PDEM.CDMAT, SFETF1PDTA_PDEM.CDREP, SFETF1PDTA_PDEM.DTRED, SFETF1PDTA_PDEM.REFER, SFETF1PDTA_PDEM.NOMSOC, SFETF1PDTA_PDEM.NACCOR, SFETF1PDTA_PDEM.COMMENT1, SFETF1PDTA_PDEM.CDATU, SFETF1PDTA_PDEM.CMTGESCO, SFETF1PDTA_PDEM.CDFINC, SFETF1PDTA_PDEM.CDAGET, Balance_Client_CTX_evolan1.NOMGEST, Balance_Client_CTX_evolan1.REFCRX, Balance_Client_CTX_evolan1.REFEXT, Balance_Client_CTX_evolan1.TIERS, Balance_Client_CTX_evolan1.CONTRAT, Balance_Client_CTX_evolan1.CDTYPE, Balance_Client_CTX_evolan1.NOMDB, Balance_Client_CTX_evolan1.SIREN, Balance_Client_CTX_evolan1.SOLDE, Balance_Client_CTX_evolan1.NONECHU, Balance_Client_CTX_evolan1.PLUS360J, Balance_Client_CTX_evolan1.DE00A30J, Balance_Client_CTX_evolan1.ETAT
FROM Balance_Client_CTX_evolan1 INNER JOIN SFETF1PDTA_PDEM ON Balance_Client_CTX_evolan1.SIREN = SFETF1PDTA_PDEM.NSIREN
WHERE (((SFETF1PDTA_PDEM.CDORIG)="W" Or (SFETF1PDTA_PDEM.CDORIG)="M") AND ((SFETF1PDTA_PDEM.DTRED)=Year(Date()) & Right("0" & Month(Date()),2) & Right("0" & Day(Date()),2)))
ORDER BY SFETF1PDTA_PDEM.DTRED; |
Partager