Incorrect Syntax near docentry

Hello Ramco,

You can use below query to simplyfy your query and get correct result,

SELECT 
    T2."CardCode", 
    (
        SELECT MAX(I0."Rate") 
        FROM DPO5 I0 
        WHERE I0."AbsEntry" = (
            SELECT I1."BaseAbs" 
            FROM PCH9 I1 
            WHERE I1."DocEntry" = T2."DocEntry"
        )
    ) AS MaxRate
FROM 
    OPCH T2;