SELECT 
    Portes.Num_porte,
    (select qryLocaux_Zones.Numero from qryLocaux_Zones where Portes.Local_Pere=qryLocaux_Zones.IDs) as Pere , 
    (select qryLocaux_Zones.Definition from qryLocaux_Zones where Portes.Local_Pere=qryLocaux_Zones.IDs) as Def_Pere,
    (select qryLocaux_Zones.Numero from qryLocaux_Zones where Portes.Local_Fils=qryLocaux_Zones.IDs) as  Fils, 
    (select qryLocaux_Zones.Definition from qryLocaux_Zones where Portes.Local_fils=qryLocaux_Zones.IDs) as Def_Fils,
    TypeOuvrant.NomTypeOuvrant, TypePorte.NomType
        FROM  TypePorte
            INNER JOIN (TypeOuvrant 
                INNER JOIN (Portes 
                    INNER JOIN qryLocaux_Zones                     
                    ON Portes.Local_pere = qryLocaux_Zones.IDs) 
                ON TypeOuvrant.ID_TypeOuvrant = Portes.Ouvrant_DIN) 
            ON TypePorte.ID_TypePorte = Portes.TypePorte
UNION SELECT
    Portes.Num_porte, 
    (select qryLocaux_Zones.Numero from qryLocaux_Zones where Portes.Local_Fils=qryLocaux_Zones.IDs) , 
    (select qryLocaux_Zones.Definition from qryLocaux_Zones where Portes.Local_fils=qryLocaux_Zones.IDs),
    (select qryLocaux_Zones.Numero from qryLocaux_Zones where Portes.Local_Pere=qryLocaux_Zones.IDs) ,
    (select qryLocaux_Zones.Definition from qryLocaux_Zones where Portes.Local_pere=qryLocaux_Zones.IDs),
    TypeOuvrant.NomTypeOuvrant, TypePorte.NomType
         FROM  TypePorte
            INNER JOIN (TypeOuvrant 
                INNER JOIN (Portes 
                    INNER JOIN qryLocaux_Zones  
                    ON Portes.Local_fils = qryLocaux_Zones.IDs) 
                ON TypeOuvrant.ID_TypeOuvrant = Portes.Ouvrant_DIN) 
            ON TypePorte.ID_TypePorte = Portes.TypePorte;