Yes, I think IBO requires a fieldname. Try

SELECT A.DealerNo, A.Country,
(SELECT B.Name FROM Country B WHERE B.Code = A.Country) as Name
FROM Dealer A
WHERE A.DealerNo = 123456

Set

At 10:24 04.04.2001 +0200, you wrote:

>Hi Set,
>
> One more question. I only tested this code below in IBConsole.
>It is working well. If I paste this code in a TIB_Query component, I have
>a error message 'Fieldname : not found'.