Hi Ales,

It work with 4.2Fn but not 4.2Fp. I get the error with 4.2Fp

Regards,
HJ

----- Original Message -----
From: <akahanek@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, January 21, 2002 7:50 PM
Subject: RE: [IBO] Lookup list in IBO 4.2Fp


> I have 4.2Fn and received similar error. The solution was not to use
> subselect in the list of required fields but join the lookup table:
>
> not
>
> SELECT a.Field,
> b.TitleID,
> (SELECT Title as The_Title
> FROM Titles t WHERE t.TitleID = b.TitleID),
> FROM (tables, joins)
>
> but
>
> SELECT a.Field,
> b.TitleID,
> t.Title as The_Title,
> FROM (tables, joins + JOIN Titles t ON ....)
>
> Ales Kahanek
>