concat

Hi, I’m trying to compare the gpa2r field in the dfkkbo table with the concatenation of the OPBEL, OPUPW, OPUPK, OPUBZ fields in the dffkop table. However, a wrong number of arguments in the function error occurs. Can you help me please

SELECT *
FROM DFFKBO
WHERE DOC2R = (
SELECT CONCAT(OPBEL, OPUPW, OPUPK, OPUBZ) AS CDFFKOP
FROM DFKKOP
);

Scroll to Top