Bonjour,
SELECT DISTINCT t_cft_srv_sr_part_idf.* ,
t_srv_part_commentaires.Commentaires AS Commentaires_Partenaire,
t_srv_part_commentaires.Distant ,
t_srv_part_commentaires.Pseudo ,
t_qualif_part.lib_qualification ,
t_etatappli.EtatAppliLib ,
ca_as.LibCourt AS LibCourtSource ,
ca_ad.LibCourt AS LibCourtDest ,
ca_as.clef_si AS Clef_Si_Source ,
ca_ad.clef_si AS Clef_Si_Dest ,
si_as.Lib_SI AS Lib_SI_Source ,
si_ad.Lib_SI AS Lib_SI_Dest ,
t_impacts.lib_impact
FROM t_cft_srv_sr_part_idf ,
t_srv_part_commentaires,
t_qualif_part ,
t_etatappli ,
t_codes_appli ca_as ,
t_codes_appli ca_ad ,
t_si si_as ,
t_si si_ad ,
t_impacts
WHERE 1 =1
AND t_cft_srv_sr_part_idf.Serveur =t_srv_part_commentaires.Serveur
AND (t_cft_srv_sr_part_idf.Serveur ='CEU00000' )
AND (t_cft_srv_sr_part_idf.SR ='s'
OR t_cft_srv_sr_part_idf.SR ='r')
AND (t_cft_srv_sr_part_idf.Impact ='')
AND (t_srv_part_commentaires.Serveur ='CEU00000' )
AND (t_srv_part_commentaires.Part ='SLIMOG00'
OR t_srv_part_commentaires.Part='CEY00009'
OR t_srv_part_commentaires.Part='EZDQSC15'
OR t_srv_part_commentaires.Part='SDIJON00')
AND t_qualif_part.qualification =('A')
AND (t_etatappli.EtatAppliClef =4
OR t_etatappli.EtatAppliClef =1)
AND (ca_as.CodeAppli ='DM'
OR ca_as.CodeAppli ='__'
OR ca_as.CodeAppli ='DM'
OR ca_as.CodeAppli ='WB'
OR ca_as.CodeAppli ='co')
AND (si_as.Clef_SI =4
OR si_as.Clef_SI =0
OR si_as.Clef_SI =3)
AND ca_ad.CodeAppli =('__')
AND (si_ad.Clef_SI =4
OR si_ad.Clef_SI =0
OR si_ad.Clef_SI =3)
AND t_impacts.impact =0
J’ai du mal a voir pourquoi ma requête ce répète pouvez vous m’aidez ?
Merci D’avance
[edit Sans-Nom]
- J’ai viré le gras (arg)
- J’ai formaté la requête -> www.sqlinform.com…
Message edité le 21/01/2011 à 20:23