SELECT 	mds.no_maitre_stage, mds.civilite, mds.nom_usuel, mds.prenom, mds.discipline, mds.numen,
e.no_etablissement, e.libelle_etablissement, e.rue, e.cp, e.localite
FROM maitre_stage mds, stage s, stagiaire st, etablissement e
WHERE
	(
		(
			s.type_stage = 'RESP'
		)
		OR
		(
			s.type_stage = 'PA'
		)
	)
	AND
	(
		(
			statut_recrutement LIKE 'Recrut%'
		)
		OR
		(
			(
				UCASE( mds.statut_recrutement ) NOT LIKE 'RECRUT%'
			)
			AND
			(
				s.no_correspondant = mds.no_maitre_stage
			)
			AND 
			(
				st.no_stagiaire = s.no_stagiaire
			)
		)
	)
	AND
	(
		(
			(
				mds.nom_usuel <> ''
			)
			AND
			(
				mds.prenom <> ''
			)
			AND
			(
				mds.prenom <> '-'
			)
			AND
			(
				mds.nom_usuel <> '-'
			)
			AND
			(
				mds.prenom <> '.'
			)
			AND
			(
				mds.nom_usuel <> '.'
			)
			AND
			(
				UPPER( mds.nom_usuel ) <> 'ZZ%'
			)
			AND
			(
				UPPER( mds.prenom ) <> 'ZZ%'
			)
		)
	)
	AND
	(
		mds.no_maitre_stage = s.no_correspondant
	)
	AND
	(
		st.no_stagiaire = s.no_stagiaire
	)
	AND
	(
		mds.code_etablissement = e.no_etablissement
	)
		
		
	GROUP BY mds.no_maitre_stage