Hello,

> sorry, outlook corrects me in German. At the moment, I have no sulution
> for the problem. Anything ideas?

Query:

SELECT
a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, a.typ
FROM
tteile a
left join tlager_sum b on (a.teilenr = b.teilenr)
WHERE
((a.minb > coalesce(b.menge,0)) and (a.typ = 1))
ORDER BY
a.teilenr


Result:

TEILENR BEZEICHNUNG MINB M TYP
PrSt110x44x3 Profilrohr E235,S2 110x44x3,0 mm gebeizt 5600mm 280
420 1


I would say your TLAGER_SUM contains a record with:

TEILENR MENGE
PrSt110x44x3 420



So results are correct?

If not give sample records for tteile and tlager_sum with DDL


Kind Regards,
Arno Brinkman
ABVisie