My problem is this one I got a query that is like this:

SELECT ID FROM TABLE LEFT JOIN ANOTHERTABLE ON TABLE.ID=ANOTHERTABLE.ID WHERE TABLE.KEY='X' AND TABLE.KEY='Y' AND TABLE.KEY='Z';

When I play this query it will return more than one id… but 3 id are the same (because each condition pick it).
I need to select the only id that show up multiple times but without using count… Basically I need to select the only ID that will be select by condition 1, 2 and 3.
I don’t really understand how to do it.

Do you know how?