select et Count multiples

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

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.

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 ?

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