Skip to Content
-1
Aug 04, 2023 at 02:13 AM

How can I use alias as join table condition?

74 Views

SELECT Z~BUKRS,
Z~BUDAT,
Z~BLDAT,
Z~HWAER AS WAERS,
Z~XBLNR,
Z~BLART,
Z~BELNR,
A~BUZEI,
A~MWSKZ,
A~SHKZG,
B~HKONT,
B~KOART,
E~MWART,
F~TEXT1,

CASE WHEN E~MWART EQ 'A' AND B~KOART EQ 'D'
THEN COALESCE( B~KUNNR , B~LIFNR )
WHEN E~MWART EQ 'V' AND B~KOART EQ 'K'
THEN COALESCE( B~LIFNR , B~KUNNR )
END AS PARTNER, <=

........


LEFT JOIN BUT020 AS H
ON PARTNER = H~PARTNER <=


ALIAS 'PARTNER' WHICH I ANNOUNCED CANT BE USED AS JOIN CONDITION WITH BUT020-PARTNER??

The program is activated well, but that join condion is not working in the end.

When using CASE in SQL Select, the alias cant be used in Table Join condition????