Using MS Sql Server 2008 I'm trying to insert multiple rows into a users\_roles table using the fancy Insert/Select syntax. When executing this query, I get the error 

> 
> Subquery returned more than 1 value. This is not permitted when the
>  subquery follows =, !=, <, <= , >, >= or when the subquery is used as
>  an expression.
> 
> 
> 

Both subqueries, when executed on their own, return the expected values. Multiple records in the first subquery and a single record in the second.

```
insert into users_roles(userid, roleid)
        select 
            (select distinct users.id as userID from users 
                inner join users_roles on users.id = users_roles.userid 
                inner join roles on users_roles.roleid = roles.id
                where roles.projectid = 1)
            , 
            (select id as roleID from roles where projectid = 1 and name = 'ALL')

```

What am I missing out here?