[Кириллов Борис]

Например вот так:
SELECT *
FROM AccountBase
WHERE (AccountId IN
(SELECT accountid
FROM accountbase accountbase1
and accountname like '%вова%'))