Versuche es mal so:
SELECT * FROM (
SELECT s4_group_id
, ( SELECT DISTINCT MATIND.s4_group_id
FROM matind MATIND
, Ass_DesignObject_S4Document2
WHERE first_reference = Zeichnung.s4_oid
AND second_reference = matind.s4_oid
) Dis_Count
FROM Zeichnung
WHERE s4_group_id <> 8321
) WHERE Dis_Count >= 2
;
SELECT * FROM (
SELECT s4_group_id
, ( SELECT DISTINCT MATIND.s4_group_id
FROM matind MATIND
, Ass_DesignObject_S4Document2
WHERE first_reference = Zeichnung.s4_oid
AND second_reference = matind.s4_oid
) Dis_Count
FROM Zeichnung
WHERE s4_group_id <> 8321
) WHERE Dis_Count >= 2
;
Comment