SELECT; Cur1.iObj_Ix,; Cur1.cName,; Cur1.c5F1,; NVL(Cur2.l1f1,.F.) AS lTeilMagaziniert,; .F. AS lMark,; A_longExpression_to_generate+; a_Field AS LongField,; A_longExpression_to_generate+; a_Field Other_LongField; FROM DBC1!Lieferung AS Cur1; LEFT OUTER JOIN (; SELECT; Cur2_1.Parent_Ix,; MAX(.T.) AS l1f1; FROM <<lcDBC1>>!Lieferteile as Cur2_1; WHERE Cur2_1.iTyp=dnTyp_LieferTeile; AND Cur2_1.iSubTyp=1; AND Cur2_1.n1F2#0; GROUP BY 1; ) AS Cur2; ON Cur1.iObj_Ix=Cur2.Parent_Ix; WHERE Cur1.iTyp=dnTyp_Lieferung; AND Cur1.iSubTyp=1Agnes