I wish to perform a multiple outer join on the table with 3 others. The join is niddeclaration. The aim is to acquire a declaration with everything else in relationship by using it during my schema. The present code did one outer join using the old syntax : in which a.byEquals B.x (+). The 'new ' syntax left outer join appears to complete the identical. My problem is by using it multiple occasions within the same request. It appears which i can't make use of a unique 'declaration d' identifier, this is exactly why I personally use 3 differents to complete exactly the same factor rather than one.

select * 
  FROM entreprise e, 
       calendrier m, 
       statut s, 
       lignedeclaration l, 
       categoriedeclaration c, 
       declaration d left OUTER JOIN saisiecategoriedeclaration sc on d.niddeclaration = sc.niddeclaration ,
       declaration de left OUTER JOIN saisielignedeclaration sl on de.niddeclaration = sl.niddeclaration,
       declaration dl left OUTER JOIN reglement r on dl.niddeclaration = r.niddeclaration
 WHERE (d.nidentreprise = e.nidentreprise) 
   AND d.niddeclaration = 12314689 
   and de.niddeclaration = 12314689 
   and dl.niddeclaration = 12314689;

Briefly I wish to do 2 normal join and three outer participate in exactly the same request. Using the 3 outer join with similar 'left' table.

You don't have to re-include declaration.

declaration d
left OUTER JOIN saisiecategoriedeclaration sc on d.niddeclaration = sc.niddeclaration
left OUTER JOIN saisielignedeclaration sl on d.niddeclaration = sl.niddeclaration
left OUTER JOIN reglement r on d.niddeclaration = r.niddeclaration

Note the omission from the commas. You may even have to re-write another tables within the query to make use of the current join syntax, I am unsure what goes on by trying to combine the syntaxes.