Select
A.AIDAT_UYEKODU,
U.UYE_UYEADSOYAD,
(cast(A.AIDAT_UYEKODU as integer)||' '||U.UYE_UYEADSOYAD) as
KODADSOYAD
from AIDAT A
JOIN UYE U
ON ( A.AIDAT_UYEKODU = U.UYEKODU)

Thanks for describing your problem very clearly!

Set

> Select
> A.AIDAT_UYEKODU,
> U.UYE_UYEADSOYAD,
> (A.AIDAT_UYEKODU||' '||U.UYE_UYEADSOYAD) as KODADSOYAD
>
> from AIDAT A
> JOIN UYE U
> ON ( A.AIDAT_UYEKODU = U.UYEKODU)
>
>
> Result of KODADSOYAD
>
> 232365.0000000000 ozzy genco
> 232365.0000000000 ozzy genco
> 232367.0000000000 abx sas
> 23123123.00000000 re werwer
> 23123123.00000000 re werwer
> 23123123.00000000 re werwer
> 23123123.00000000 re werwer
>
> Required Result
>
> 232365 ozzy genco
> 232365 ozzy genco
> 232367 abx sas
> 23123123 re werwer
> 23123123 re werwer
> 23123123 re werwer
> 23123123 re werwer
>
> What Can I do for this?