concat

DeborahPiccoli — Fri, 23 Feb 2024 16:54:33 GMT

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
);

Re: concat

Cocquerel — Mon, 26 Feb 2024 20:21:05 GMT

You can used the following syntax instead:
SELECT *
FROM DFFKBO
WHERE DOC2R = (
SELECT OPBEL || OPUPW || OPUPK || OPUBZ AS CDFFKOP
FROM DFKKOP
);

topic concat in Artificial Intelligence Forum

concat

Re: concat