SELECT Ma.Nombre AS Marca, (SELECT Mo.Nombre FROM Modelo Mo WHERE Mo.IdMarca = Ma.IdMarca) AS Modelo FROM Marca Ma