Invalid column name

Question

Why gives this code next error on the last line?

Invalid column name 'rId'.

;WITH x AS 
(
    SELECT Id as rId
    FROM Roles
    WHERE Minimum >= (select punten 
                      from Users 
                      where id = 'abc')
)
INSERT INTO UserRoles (UserId, RoleId) 
VALUES ('abc', rId);

I use MS-SQL server.

Answer 1

I've found it! The code must be this:

;WITH rs AS 
(
    SELECT Id 
    FROM AspNetRoles
    WHERE Minimum >= (select punten from AspNetUsers where id = 'abc')
)
INSERT INTO AspNetUserRoles (UserId, RoleId)
SELECT 'abc', rs.id
FROM rs;