SELECT X.*,Y.*,Z.* FROM X,Y,Z WHERE X.CS_PERS_PRO Y.CodeCS AND X.CS_PERS_PRO Z.CODE_SERVICE
SELECT * FROM X, (SELECT FY AS FYZ FROM Y UNION ALL SELECT FZ AS FYZ FROM Z) YZ WHERE X.FK = YZ.FYZ;
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT MATRI_PERSONNE, LBLPRO FROM PERSONNE, (SELECT LibelleCS as LBLPRO, CodeCS AS CentrePro FROM ENTITES UNION ALL SELECT LIBELLE_SERVICE as LBLPRO, CODE_SERVICE AS CentrePro FROM SERVICE_SEDIT) ENTITEPRO WHERE PERSONNE.CS_PERS_PRO = ENTITEPRO.CentrePro