1 2 3 4 5 6 7 8 9 10 11 12
| SELECT NUMDOSSIER, DATEANNONCE,OPERATRICE, DATETRAITEMENT,
NOMCONTACT, TYPEANNONCE, TELCONTACT, CPCONTACT, VILLECONTACT, PREFIXEANNONCE, ETATDOSSIER,
'pas de réponse' as EtatAnnonce, LIEUANNONCE, CPANNONCE FROM ANNONCES
WHERE NUMDOSSIER is not null
AND NEPASCONTACTER = 1
UNION ALL
SELECT NUMDOSSIER, DATEANNONCE,OPERATRICE, DATETRAITEMENT,
NOMCONTACT, TYPEANNONCE, TELCONTACT, CPCONTACT, VILLECONTACT, PREFIXEANNONCE, ETATDOSSIER,
'pas de réponse' as EtatAnnonce, LIEUANNONCE, CPANNONCE FROM NOREPONSE
WHERE NUMDOSSIER is not null
AND EtatDossier > 0
AND NEPASCONTACTER = 1 |
Partager