Did you trie with inner join?

SELECT A.DealerNo, A.Country, B.Name
FROM Dealer A
INNER JOIN Country B ON B.Code = A.Country
WHERE A.DealerNo = 123456

HTH, Aljosa

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 04, 2001 10:39 AM
Subject: RE: To SET [IBO] Slow query question


> 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'.
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>