You can wrap that first part into a INNER JOIN statement or use a CTE like someone else mentioned