Constraint Violating Yak Guru
Very Important crosS Applying yaK Herder
FROM Table t
INNER JOIN (SELECT ID
GROUP BY ID
HAVING SUM(CASE WHEN status='closed' THEN 1 ELSE 0 END)=0
On t1.ID = t.ID
quote:Originally posted by peaceI meant those with 'closed' status will not grab the whole ID.
quote:Originally posted by peaceYa i tried.But the id with 'closed' still included.
quote:Originally posted by peacesorry it works fine now.Thanks