More efficient way to write multiple "AND"?
Not sure if that's is faster than what you have, but you can try

SELECT tableA.NO
FROM tableA
WHERE tableA.NO
IN 
(
   SELECT GRI_NO FROM tableBB WHERE GRO_NO IN (62,50,70) 
   GROUP BY GRI_NO
   HAVING COUNT(DISTINCT GRO_NO) =3
)