Brandlhuber Florian
New Member
"ON clause outer join predicate" contains invalid column reference. (12480)"
Really? Progress doesn't really mean that.
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: