usi .recordcount, oppure

SELECT COUNT(*) FROM (SELECT nomi FROM utenti UNION select nomi2 FROM utenti2)