--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1
(
  b varchar(30)
) ENGINE = BDB ;
insert into t1 values ('one');
commit ;

select b FROM t1 outer_table where
exists (select 'two' from t1 where 'two' = outer_table.b ) ;