One way would be"

select name from  (cat Union dog) join (animal) on id where color='brown';