on 2022 May 17 9:02 AM
Hi
CASE WHEN (inTab."/BIC/C55CONTID" is NOT null)
THEN
CASE WHEN (inTab."/BIC/CRCBECFVN" >1 ) THEN
(SELECT "/BIC/K5SCDCEC" FROM "/BIC/AZD_TVOG2" WHERE "/BIC/AZD_TVOG2"."/BIC/CRCBECFVN" = 1) AS "/BIC/K5SCDCEC",
ELSE
"/BIC/K5SCDCEC" AS "/BIC/K5SCDCEC"
END
END
after writing this logic gives me an error on the AS, can you tell me the reason?
Hi,
like everyone else said, you have "AS" in the wrong place, but also I see two CASE WHEN but only one ELSE statements, you might want to check that part.
BR,
Matija
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.