Roquete

Bonjour,

Bonjour,


CREATE TABLE CONTROLE(
ID_CONTROLE VARCHAR(10)NOT NULL,
ID_UNITE_FORMATION VARCHAR(10)NOT NULL,
CODE_TYPE_CONT VARCHAR(10)NOT NULL,
DATE_COTROLE DATETIME NOT NULL,
OBS_CONTROLEUR VARCHAR(25)NOT NULL,
CONSTRAINT PK_CONTROLE PRIMARY KEY (ID_CONTROLE),
CONSTRAINT FK_UF_CONT FOREIGN KEY (ID_UNITE_FORMATION) REFERENCES UNITE_FORMATION,
CONSTRAINT FK_TYPE_CONT FOREIGN KEY (CODE_TYPE_CONT) REFERENCES TYPE_CONT);



CREATE TABLE TYPE_CONT(
CODE_TYPE_CONT VARCHAR(10)NOT NULL,
LIBELLE_TYPE VARCHAR(25)NOT NULL,
CONSTRAINT PK_TYPE_CONT PRIMARY KEY (CODE_TYPE_CONT));


CREATE TABLE PASSER(
ID_STAGIAIRE VARCHAR(10)NOT NULL,
ID_CONTROLE VARCHAR(10)NOT NULL,
NOTE int NOT NULL,
CONSTRAINT PK_PASSER PRIMARY KEY (ID_STAGIAIRE,ID_CONTROLE),
CONSTRAINT FK_STG_PASS FOREIGN KEY (ID_STAGIAIRE) REFERENCES STAGIAIRE,
CONSTRAINT FK_CONT_PASS FOREIGN KEY (ID_CONTROLE) REFERENCES CONTROLE);

le champ LIBELLE_TYPE contient controle continue,exam pratique,exam theorique
je veux que controle continue,exam pratique,exam theorique afiche comme des champs contient des notes chacune. par une requete