1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| SELECT AFFAIRE.NumeroAffaire AS 'Numéro d affaire',
AFFAIRE.DesignationCompte AS 'Description affaire',
AFFAIRE.DateCreation AS 'Date création affaire',
COME.NoCommande AS 'Numero de la commande',
COME.VarAlphaUtil AS 'Designation de la commande',
COME.DateCreation AS 'Date creation de la commande',
COME.NoAccuseReception AS 'Numéro accuse de réception',
COME.MtHtRemiseEscompt AS 'Montant HT',
COME.MontantTtc AS 'Montant TTC',
FAVC.NoFacture
FROM AFFAIRE
LEFT OUTER JOIN COME
ON AFFAIRE.VarAlphaUtil = COME.CodeClient
AND AFFAIRE.NumeroAffaire = COME.NumeroAffairePere
LEFT OUTER JOIN favc ON favc.numeroaffaire = come.numeroaffairepere
WHERE AFFAIRE.VarAlphaUtil = @i00701$
UNION
SELECT NULL AS 'Numéro d affaire',
NULL AS 'Description affaire',
NULL AS 'Date création affaire',
COME.NoCommande AS 'Numero de la commande',
COME.VarAlphaUtil AS 'Designation de la commande',
COME.DateCreation AS 'Date creation de la commande',
COME.NoAccuseReception AS 'Numéro accuse de réception',
COME.MtHtRemiseEscompt AS 'Montant HT',
COME.MontantTtc AS 'Montant TTC',
FAVC.NoFacture
FROM COME
LEFT OUTER JOIN favc ON favc.NoCommande = come.NoCommande -- Supposition sur la condition de jointure
WHERE COME.NumeroAffairePere IS NULL |
Partager