Radovan Bukoci wrote:

> Hallo,
>
> Please, I have trouble to run this query:
>
> SQL> select cisloof, OSTAVAZAP, FORMAUHRADY, sum(prijem) AS prijem1 FROM
> a_OdbFak LEFT JOIN Uhrady_do_20046
> CON> ON 'OF' + a_OdbFak.CISLOOF = Uhrady_do_20046.PREPOJKOD WHERE
> DATUMVYST>='05/01/2004'
> CON> GROUP BY cisloof, ostavazap, formauhrady;
>
> getting error:
>
> Dynamic SQL Error
> -expression evaluation not supported
>
> I think the trouble is in
> ... ON 'OF' + a_OdbFak.CISLOOF = Uhrady_do_20046.PREPOJKOD ...
> ...

"+" ?
If you want concatenation, use "||" (SQL std.):
... on 'OF' || a_a_OdbFak.CISLOOF = ...

--
Aage J.