1 2 3 4 5 6 7 8 9
| SELECT DISTINCT
dbo.tb_conso.GJEFZC AS [Num facture], dbo.tb_conso.GJAN8X AS [Num compte], dbo.cras.EEB8ZC AS [Num abonné],
dbo.cras.EEBEZB AS [Periode appel], dbo.cras.EEAWZK AS Montant, dbo.cras.NUGUFX AS Emetteur, dbo.cras.EECOZC AS [APN utilisé],
dbo.cras.EECSW3 AS [Type appel], dbo.cras.EEF9ZJ AS [Donnée de localisation], dbo.cras.EECOW3, dbo.cras.EEHGW2,
dbo.cras.EEHJW2 AS [Volume en ko], dbo.cras.EED8ZE, dbo.cras.EEB6ZK AS dureeEEB6ZK, dbo.cras.EECFZC AS dureeEECFZC, dbo.cras.EEBSW2,
dbo.cras.EEUBW3 AS [Code service], dbo.cras.EEELZE, dbo.cras.EEH7ZE, dbo.cras.EEIVW3 AS [Valorisé par snobs],
dbo.cras.EEAEZI AS [Heure d'appel']
FROM dbo.tb_conso LEFT OUTER JOIN
dbo.cras ON dbo.tb_conso.RDB8ZC = dbo.cras.EEB8ZC AND dbo.tb_conso.RDIQWC = dbo.cras.EEGOZC |
Partager