Subject Re: [IBO] Multiple Rows in a singleton fetch
Author Jörg Buhren
Hi Guido,

guido.klapperich@... schrieb:
> I have the following Query
> select CS.CSID,
> CS.CSSAPNR,
> CS.CSNRFIRST,
> CS.CSNRLAST,
> CS.CSDANAME1,
> CS.CSDACITY,
> CS.CSDAZIPCODE,
> CS.CSDASTREET
> from USERS_SALESAREAS UA join CUSTOMERS CS
> on UA.UASAID=CS.CSSAID
> where UA.UAUSID=:USID
>
> KeyLinks: CUSTOMERS.CSID
is that correct ?
try to use 'USERS_SALESAREAS.UAUSID'

[...]

Regards
Jörg