select  isnull(autor.PseudonimoAutor, isnull(autor.NomAutor,' ')+' ' + isnull(autor.apellidoAutor,'')) as nom from autor inner join relAutorserie on autor.idAutor=relAutorserie.idAutor where idserie=470