sql - Return List of Records where 1 ID is linked to 2 different PKs

Question

First of all, apologies for the title - wasn't sure how to word it.

Essentially I have this data:

ID	RuleID	AccountID
1	1234	ABC001
2	5678	DEF001
3	1234	GHI001
4	1234	ABC001

Answer 1

You can try EXISTS as follows:

SELECT * FROM #rules r
where exists 
  (select 1 from #rules rr
    where rr.RuleID = r.RuleID and rr.AccountID <> r.AccountID);