select a.name from cat a, animal b where b.color='brown' and a.id=b.id;

this will definitely do.................