I am trying to find employees names with title who don't receive any bonus and I get the following error:

WITH Result AS
(
    SELECT
        A.assoc_id  
    FROM
        Employee A 
    WHERE 
        assoc_id NOT IN (SELECT B.assoc_ref_id FROM bonus B) 
)
SELECT
    E.firstname, E.lastname, T.assoc_title 
FROM
    Employee E 
INNER JOIN
    Title T ON E.assoc_id = T.assoc_ref_id
WHERE
    E.assoc_id IN (Result ) /*(Result ) throws error*/

However, this works fine for me and I get the desired result:

WITH Result AS
(
    SELECT
        E.firstname, E.lastname, T.assoc_title 
    FROM
        Employee E 
    INNER JOIN
        Title T ON E.assoc_id = T.assoc_ref_id
    WHERE
        E.assoc_id IN (SELECT A.assoc_id FROM Employee A 
                       WHERE assoc_id NOT IN (SELECT B.assoc_ref_id 
                                              FROM bonus B))
)
SELECT * FROM Result

What wrong am I doing in the first query? Can we use joins while querying CTE result at all?

Thanks.