Nom de la vue : v_entreprise

CREATE VIEW v_entreprise
AS
SELECT e.ENTNUM,ENTNOM, ENTADRESSE1, ENTADRESSE2, ENTCP, ENTVILLE, ENTPAYS, ENTTELEPHONE, ENTFAX, ENTEMAIL, EFFECTIF, TYPEACTIVITE, COMMENTAIRE, CODECONFIDENTIALITE, ALERTEENTREPRISE, ACCEPTSTAGE, NBSTAGEACCEPT,
	NULL AS SERNUM, NULL AS SERNOM, NULL AS SERTELEPHONE, NULL AS SERFAX, NULL AS SERADRESSE1, NULL AS SERADRESSE2, NULL AS SERCP, NULL AS SERVILLE, NULL AS SERPAYS, NULL AS ALERTESERVICE, NULL AS ACCEPTESTAGE, NULL AS NBSTAGEACCEPTE,
	resp.RESNUM, resp.ENTNUM AS RESPENTNUM, resp.SERNUM AS RESPSERNUM, RESCIVILITE, RESNOM, RESPRENOM, RESFONCTION, RESTELEPHONE, RESGSM, RESEMAIL, RESFAX, RESCOM
	FROM `entreprise` e INNER JOIN responsable resp on e.ENTNUM=resp.ENTNUM
	AND resp.SERNUM IS NULL
	
UNION
	
SELECT e.ENTNUM,ENTNOM, ENTADRESSE1, ENTADRESSE2, ENTCP, ENTVILLE, ENTPAYS, ENTTELEPHONE, ENTFAX, ENTEMAIL, EFFECTIF, TYPEACTIVITE, COMMENTAIRE, CODECONFIDENTIALITE, ALERTEENTREPRISE, ACCEPTSTAGE, NBSTAGEACCEPT,
	s.SERNUM, SERNOM, SERTELEPHONE, SERFAX, SERADRESSE1, SERADRESSE2, SERCP, SERVILLE, SERPAYS, ALERTESERVICE, ACCEPTESTAGE, NBSTAGEACCEPTE,
	resp.RESNUM, resp.ENTNUM AS RESPENTNUM, resp.SERNUM AS RESPSERNUM, RESCIVILITE, RESNOM, RESPRENOM, RESFONCTION, RESTELEPHONE, RESGSM, RESEMAIL, RESFAX, RESCOM
	FROM `entreprise` e INNER join service s on e.ENTNUM=s.ENTNUM
			inner join responsable resp on s.SERNUM=resp.SERNUM
			
ORDER BY ENTNOM;