Why where clause is not executing in SQL CTE(Common Table Expression) but works with Join?

While Executing SQL query, in Common Table Expression is where clause is different from join clause ?