SELECT SERIES.Serie, SERIES.IdFabricante, SERIES.Descripcion, FABRICANTES.Marca FROM SERIES LEFT JOIN FABRICANTES ON SERIES.IdFabricante=FABRICANTES.IdFabricante WHERE IdSerie=1421 AND FABRICANTES.Activo='1' AND SERIES.Activo='1'