formation dune requete

T'aurais plus de chances si tu demande ça sur http://www.sqlfr.com/

Exemple directement issu de mon taf par copier-coller:

"SELECT DISTINCT [DATE NAISSANCE] AS a,gp.[CODE PATIENT] AS b,"
"[CODE TYPE SEXE] AS c,[CONNU DEPUIS] AS d,[CODE POSTAL] AS e,"
"[CODE TYPE LOGEMENT] AS f,[CODE CATEGORIE LOGEMENT] AS g,"
"[CODE TYPE SITUATION] AS h,[CODE TYPE MODE DE VIE] AS i,"
"[CODE TYPE PROFESSION] AS j,[CODE TYPE ACTIVITE] AS k,[CODE SUIVI PAR] AS l,"
"AES AS m,[ASS COMMENTAIRE] AS n,[CODE TIERS PAYANT] AS o,"
"[CODE TYPE CONTRAT] AS p FROM [GLB PATIENT] AS gp,[CON CONSULTATION] AS cc WHERE "
"[CODE TYPE SEXE] IS NOT NULL AND gp.[CODE PATIENT] = cc.[code patient]"

Les tables indiquées derrière 'FROM' et les champs de correspondance dans la clause 'WHERE'.
Comme dit par Zootella, plus amples détails sur sqlfr.com ou vbfrance.com si c'est sur Access.

ciao...
[ Lien ]
BruNews, MVP VC++