Similar -

WITH CTE AS (

SELECT Project

FROM Project_Category

WHERE Category = '3')

SELECT c.Project

FROM CTE c JOIN Project_Category p ON p.Project = c.Project AND p.Category = '6'