Using a Having clause with an outer join
This is not my forte, but I am sure that you need a GROUP BY in there.

Also, out the ORDER BY line at the end of your statement.  Something like this :

SELECT
  I.CARD_BIN BIN
FROM 
  GE_ICA_BIN I
LEFT OUTER JOIN GE_PAYEE_VALIDATION P ON I.CARD_BIN = P.CARD_BIN
LEFT OUTER JOIN GE_PAYEE PP ON PP.PAYEE_CODE = P.PAYEE_CODE
group by I.CARD_BIN
HAVING COUNT(*) &gt; 1
ORDER BY I.CARD_BIN;