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 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.