Discussion :

[novasenha]

Bonjour,
J’aimerais beaucoup avoir un peu d’aide s.v.p.
Je construit cette requête afin de vérifier si un tel enregistrement se trouve dans une des tables à vérifier mais ça ne manche pas.
La voilà :
SELECT
(SELECT COUNT(par) FROM NC_COMMENTAIRES) AS nb_comment,
(SELECT COUNT(numero_employe) FROM NC_DOSSIERS) AS nb_dossier,
(SELECT COUNT(qui_traitement) FROM NC_GESTION) AS nb_gestion,
(SELECT COUNT(no_invite) FROM NC_historique_invites) AS nb_historique,
(SELECT COUNT(no_invite) FROM NC_INVITES) AS nb_invites,
(SELECT COUNT(id_responsable) FROM NC_responsable) AS nb_responsible,
(SELECT COUNT(qui) FROM PAC_discuss) AS nb_discuss,
(SELECT COUNT(id_responsable) FROM PAC_discuss_droits) AS nb_discuss_droits,
(SELECT COUNT(id_employe) FROM PAC_dossiers) AS nb_pasdossiers,
(SELECT COUNT(id_employe) FROM PAC_gagnants) AS nb_gagnants,
(SELECT COUNT(no_employe) FROM PAC_new_comment) AS nb_new_comments,
(SELECT COUNT(responsable_comite) FROM PAC_rep_comite) AS nb_comite,
(SELECT COUNT(responsable_direction) FROM PAC_rep_direction) AS nb_direction
FROM PAC_employes WHERE id_employe=255

Je vous remercie d'avance

[Maljuna Kris]

Saluton,
J'ai compté, 12 sous-requêtes, c'est un peu délirant.
Je crois qu'en mettant les tables en jointures et en faisant des COUNT(DISTINCT nom_colonne) tu devrais pouvoir t'en sortir.

[novasenha]

Et bien, avec "distinc" le résultat semble déjà mieux mais pour la jointure, ça va pas tellement. je ne trouve pas la bonne syntaxe, avec cette longue requête...
Pourrais-tu me donner un exemple s.v.p ?

[novasenha]

Bon, je ne pense pas qu'elle est parfaite mais elle marche:

SELECT COUNT( id_employe ) , (

SELECT COUNT( DISTINCT par )
FROM NC_COMMENTAIRES
WHERE par =$id_employe
) AS nb_comment, (

SELECT COUNT( DISTINCT numero_employe )
FROM NC_DOSSIERS
WHERE numero_employe =$id_employe
) AS nb_dossier, (

SELECT COUNT( DISTINCT qui_traitement )
FROM NC_GESTION
WHERE qui_traitement =$id_employe
) AS nb_gestion, (

SELECT COUNT( DISTINCT no_invite )
FROM NC_historique_invites
WHERE no_invite =$id_employe
) AS nb_historique, (

SELECT COUNT( DISTINCT no_invite )
FROM NC_INVITES
WHERE no_invite =$id_employe
) AS nb_invites, (

SELECT COUNT( DISTINCT id_responsable )
FROM NC_responsable
WHERE id_responsable =$id_employe
) AS nb_responsible, (

SELECT COUNT( DISTINCT qui )
FROM PAC_discuss
WHERE qui =$id_employe
) AS nb_discuss, (

SELECT COUNT( DISTINCT id_responsable )
FROM PAC_discuss_droits
WHERE id_responsable =$id_employe
) AS nb_discuss_droits, (

SELECT COUNT( DISTINCT id_employe )
FROM PAC_dossiers
WHERE id_employe =$id_employe
) AS nb_pasdossiers, (

SELECT COUNT( DISTINCT id_employe )
FROM PAC_gagnants
WHERE id_employe =$id_employe
) AS nb_gagnants, (

SELECT COUNT( DISTINCT no_employe )
FROM PAC_new_comment
WHERE no_employe =$id_employe
) AS nb_new_comments, (

SELECT COUNT( DISTINCT responsable_comite )
FROM PAC_rep_comite
WHERE responsable_comite =$id_employe
) AS nb_comite, (

SELECT COUNT( DISTINCT responsable_direction )
FROM PAC_rep_direction
WHERE responsable_direction =$id_employe
) AS nb_direction
FROM PAC_employes
WHERE id_employe =$id_employe

Merci beaucoup Maljuna Kris