On Clause Outer Join Predicate

"ON clause outer join predicate" contains invalid column reference. (12480)"

Really? Progress doesn't really mean that.
Code:
SELECT
   A.Firma,
   A.PP_Auftrag_Obj,
   A.Auftrag,
   A.AuftragsStatus,
   (
       CASE
           WHEN A.BelegNummer != 0 THEN A.BelegNummer
           ELSE A.KommissionsNr
       END
   ) AS BELEGNUMMER,
   A.EndTermin - CURDATE() AS DIFF_ENDE,
   A.Kunde,
   A.PositionsNr,
   A.Produktionsmenge,
   A.RueckMeldeNr,
   A.Prozess_Herkunft,
   A.Sollmenge AS SOLL_MENGE,
   A.Wunschtermin,
   A.WunschStartTermin - CURDATE() AS DIFF,
   A.WunschStartTermin AS START_TERMIN,
   (A.Sollmenge - A.FertigMenge) AS OFFEN,
   A.FertigMenge AS IST_MENGE,
   CASE
       WHEN A.AuftragsStatus = 'R' THEN 0
       ELSE 1
   END AS SORT_STATUS,
 
   B.Artikel,
   B.ArtikelGruppe,
   B.S_Artikel_Obj,
   B.Sparte,
   B1.Bezeichnung AS ARTIKEL_BEZ,
 
   C.S_Kunde_Obj,
   C.Suchbegriff,
   C1.Name1 AS NAME,
   C2.Branche,
   C2.Bezeichnung AS BRANCHE_BEZ
FROM PUB.PP_Auftrag A
LEFT JOIN PUB.S_Artikel B ON A.Firma = B.Firma AND A.Artikel = B.Artikel
LEFT JOIN PUB.S_ArtikelSpr B1 ON B.Firma = B1.Firma AND B.Artikel = B1.Artikel AND B1.Sprache = 'D'
LEFT JOIN PUB.S_Kunde C ON A.Firma = C.Firma AND A.Kunde = C.Kunde
LEFT JOIN PUB.S_Adresse C1 ON C.AdressNr = C1.AdressNr
LEFT JOIN PUB.S_BrancheSpr C2 ON C.Branche = C2.Branche AND C2.Sprache = 'D'
WHERE
   A.Firma = '100'
    AND (
       A.PP_Auftrag_Obj = 'PA0961:z:b8d6d68b99c27f862114307fc40813f5'
       OR A.PP_Auftrag_Obj IN (
           SELECT
               AA.Coverage_Obj
           FROM PUB.PP_Auftrag AA
           WHERE
               AA.Firma = '100'
               AND AA.PP_Auftrag_Obj = 'PA0961:z:b8d6d68b99c27f862114307fc40813f5'
       )
       OR A.Coverage_Obj = 'PA0961:z:b8d6d68b99c27f862114307fc40813f5'
   )
WITH(NOLOCK)
 
Last edited by a moderator:
Top