select s.*,b.brand  from series s,brand b where s.b_id = b.id and s.id = '394'