Subconsulta?

[Libras]

Algo asi creo que funcionaria

Código SQL:

SELECT t1.REF,t1.elem FROM F_datos AS t1
LEFT JOIN(
SELECT REF FROM F_DATOS GROUP BY REF  HAVING COUNT(*) < 2) AS t2 ON (t1.REF=t2.REF)