Subject | Re: [IBO] Multiple Rows in a singleton fetch |
---|---|
Author | Jörg Buhren |
Post date | 2002-11-13T11:46:34Z |
Hi Guido,
guido.klapperich@... schrieb:
try to use 'USERS_SALESAREAS.UAUSID'
[...]
Regards
Jörg
guido.klapperich@... schrieb:
> I have the following Queryis that correct ?
> 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
try to use 'USERS_SALESAREAS.UAUSID'
[...]
Regards
Jörg