"Subquery returned more than 1 value" - problem

I am getting this message:
"Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
an expression.
The statement has been terminated."
Is there any solution for this problem?
Maybe some utility for repairing damaged database ?

You do not have a damaged database. You have a bad query. It is exactly as the error message states. Please post your query and let's see where it's erroneous.

use "IN" instead of "="

--fails if there are more than one row in table2

select * from table1 where name=(select
name from table2)

--Try this
select * from table1 where name in (select
name from table2)