Re: search problems

[Peter Brawley]

Simplest solution: given tbl(name,genre) and a band named "thisband" ...

select name
from tbl
where genre = ( select genre from tbl where name="thisband" );