1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT DbChaine AS 'Ch.', DbClient AS 'Client', DbNom AS 'Nom', DbVille AS 'Ville', DbProvince AS 'Prov.',
MAX(F.CfDateFacture) AS 'Dern. Facture', DbStatut AS 'St.',
DbEntrepot AS 'En.'
FROM tDbClient C
JOIN tCfFacture F ON F.CfClientLivre = C.DbClient
GROUP BY DbChaine, DbClient, DbNom, DbVille, DbProvince, DbStatut, DbEntrepot
UNION
SELECT DISTINCT DbChaine AS 'Ch.', DbClient AS 'Client',
DbNom AS 'Nom', DbVille AS 'Ville', DbProvince AS 'Prov.',
DbDateDerVte, DbStatut AS 'St.', DbEntrepot AS 'En.'
FROM tDbClient
WHERE DbClient NOT IN (SELECT CfClientLivre FROM tCfFacture)
ORDER BY DbChaine, DbClient |
Partager