dramaqueen (10/25/2016)
I managed to solve it.
SELECT O.ow_idFROM props.dp_owner O
JOIN props.dp_entry E
ON O.ow_id = E.dp_person
JOIN props.dp_item I
ON E.dp_id = I.dpi_dp_id
WHERE I.dpi_status NOT IN ( '7' ) --DISPOSED
AND O.ow_id IN (SELECT O.ow_id
FROM props.dp_owner O
JOIN props.dp_entry E
ON O.ow_id = E.dp_person
JOIN props.dp_item I
ON E.dp_id = I.dpi_dp_id
WHERE I.dpi_status IN ( '7' ) --DISPOSED
GROUP BY O.ow_id)
GROUP BY O.ow_id
That, will definitely be slow with a larger dataset.
EDIT: Amended using your naming conventions above:
SELECT O.ow_id
FROM props.dp_owner O
WHERE EXISTS (SELECT sqi.dpi_status
FROM props.dp_entry sqe
JOIN props.dp_item sqi ON sqe.dp_id = sqi.dpi_dp_id
WHERE sqe.dp_persoD = O.ow_id
AND sqi.dpi_status = 7);
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk