1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SQl.Add('SELECT DISTINCT D.Numerodossier, P.RefProjet, '
+'C.NomSociete, C.NomClient, C.PrenomClient, '
+'P.DateDebutProjet, D.Numero_rue, D.Nom_rue, '
+'D.Commune, P.Facturation, P.DescriptionProjet');
SQL.Add('FROM (DOSSIER as d INNER JOIN (CLIENT as c INNER JOIN PROJETS as P'
+'ON C.RefClient = P.RefClient) '
+'ON D.RefDossier = P.RefDossier) '
+'INNER JOIN (EMPLOYES as e INNER JOIN TACHES_PAR_PROJET as tpp '
+'ON E.RefEmploye = TPP.RefEmploye) '
+'ON P.RefProjet = TPP.RefProjet');
SQL.Add('WHERE E.NomFamille='+QuotedStr(Value));
SQL.Add('Group By D.Numerodossier, P.RefProjet, '
+'C.NomSociete, C.NomClient, C.PrenomClient, '
+'P.DateDebutProjet, D.Numero_rue, D.Nom_rue, '
+'D.Commune, P.Facturation, P.DescriptionProjet');
Open; |
Partager