Can't get value from database using uipath

hi all,

I have a problem when i get value from database using sql code
it seem like my code is wrong but i dont know exactly wherer i’m wrong
please help

My code :
SELECT ORFN5C,CORN5C,ITMC5E,IT1IA0,IT2IA0,IT3IA0,ORDN5E,SUM(ORRQ5E) AS ORRQ5E,OQUC5E,CAST(LNGV5E AS DOUBLE ) AS LNGV5E,LUNC5E,CLRC5E,CLCC51, SUNP5E,SDTK6J, OINU5C,MAX (NDCU5F) AS Ex_Factory,DLVU5F,CN1I09, INVN6J,DK1C5C,DK2C5C,SMPF5C,BYRC5C,CSTC5C, FM1X6A,FM2X6A,FM3X6A,FM4X6A,FM5X6A,FM6X6A,FM7X6A,FM8X6A,FM9X6A,FMAX6A FROM WAVEDLIB.S5C00 LEFT OUTER JOIN WAVEDLIB.S5A00 ON ORDN5C = ORDN5A LEFT OUTER JOIN WAVEDLIB.S6A00 ON ORDN5C = ORDN6A LEFT OUTER JOIN WAVEDLIB.S3900 ON CSTC5C = CLNC39 LEFT OUTER JOIN WAVEDLIB.S3500 ON BYRC5C = BYRC35 LEFT OUTER JOIN WAVEDLIB.C0500 ON SPRC5C = EMPC05 LEFT OUTER JOIN WAVEDLIB.S5E00 ON ORDN5C = ORDN5E LEFT OUTER JOIN WAVEDLIB.FA000 ON ITMC5E = ITMCA0 LEFT OUTER JOIN WAVEDLIB.S6J00 ON ORDN5E||OSBN5E = ORDN6J||OSBN6J LEFT OUTER JOIN WAVEDLIB.S5F00 ON ORDN5E||OSBN5E = ORDN5F||OSBN5F LEFT OUTER JOIN WAVEDLIB.C0900 ON PSTC5F = DDTC09 LEFT OUTER JOIN WAVEDLIB.S5100 BYRC5C||CSTC5C||CLRC5E = BYRC51||CLNC51||CLRC51 WHERE DGRC09 = ‘PSTC’ AND OINU5C between ‘20190712’ and ‘20190912’ AND CSTC5C IN ‘001626’ GROUP BY ORFN5C,CORN5C,ITMC5E,IT1IA0,IT2IA0,IT3IA0,ORDN5E,ORRQ5E,OQUC5E,LNGV5E,LUNC5E,CLRC5E,CLCC51,SUNP5E,SDTK6J, OINU5C,DLVU5F,CN1I09, INVN6J,DK1C5C,DK2C5C,SMPF5C,BYRC5C,CSTC5C, FM1X6A,FM2X6A,FM3X6A,FM4X6A,FM5X6A,FM6X6A,FM7X6A,FM8X6A,FM9X6A,FMAX6A

Shouldn’t here be CSTC5C=‘001626’ or CSTC5C IN (‘001626’)?

I’d say the token || was not valid.

|| represents string concatenation. Unfortunately, string concatenation is not completely portable across all sql dialects.

Check this: sql - What is the difference between "||" operator and concat function in Oracle? - Stack Overflow