Hi Helen

Thanks for trying to help. Here the exact SQL:

SELECT DISTINCT
PR.SUCHBEGRIFF as Liegenschaft,
AD.VORNAME,
AD.NAME1,
KO.NUMMER,
KO.TYP
FROM
ADRESSE ad,
ADRESSKATEGORIE ak,
ADRESSE_ADRESSKATEGORIE aa,
VERTEILEREINTRAG ve,
PROJEKT pr
left outer join KOMMUNIKATION ko on AD.ID = KO.ADRESSE_ID
WHERE
AK.SUCHBEGRIFF = 'Hauswart' AND
AK.ID = AA.ADRESSKATEGORIE_ID AND
AA.ADRESSE_ID = AD.ID AND
VE.ADRESSE_ID = AD.ID AND
VE.VERTEILER_ID = PR.BETEILIGTEVERTEILER_ID AND
KO.TYP = 'Privat'

Kind Regards
Philipp

2010/8/31 Helen Borrie <helebor@...>

>
>
> At 08:04 PM 31/08/2010, you wrote:
> >The join command works only when its used alone but not with left, right
> etc....
> >When I use for example left outer join..... then I get the following
> error: 'The cursor identified in the update or delete statement is not
> positioned in a row. No current record for fetch operation.'
> >Can someone help me ?
>
> Provide the exact SQL of the failing statement.
>
> ./heLen
>
>
>

[Non-text portions of this message have been removed]