[SQL] Left outer join and sub queries alias

Hello, I try to make work this request: select * from ( select * from personne_nom where personne_nom_pal=1 ) as tmp, personne left outer join tmp on ( personne.personne_id = tmp.personne_nom_personne_id ) where personne_id=57 The error on execution is: ERROR: Relation "tmp" doe

[SQL] Combine 'left outer join' and 'inner join'

Hello, I have a problem with a sql request on Postgresql. It uses 'left outer join' and 'inner join' Here is my request: select a.acte_id,a.acte_libelle,a.acte_url_image,a.acte_page, a.acte_texte,a.acte_marge_texte,a.acte_date,a.acte_registre_page, commune.commune_id,commune.commune_nom,commune.