> -----Original Message-----
> From: Nico Callewaert [mailto:ncw@...]
> Sent: Miércoles 4 de Abril de 2001 4:24
>
> I have
> a error message 'Fieldname : not found'. I'm already looking 2 hours at
> it, but couldn't solve it maybe you know something.
> Even this little piece of code is not working in a IB_Query,
> removing the A.
> in fornt of the fielnames doesn't help
>
> SELECT A.DealerNo, A.Country,
> (SELECT B.Name FROM Country B WHERE B.Code = A.Country)
> FROM Dealer A
> WHERE A.DealerNo = 123456

(SELECT B.Name FROM Country B WHERE B.Code = A.Country) AS COUNTRYNAME

This is actually a bug in IB. Jason could give the column an arbitrary name,
maybe.

C.