Oh, an important question regarding the join

I learnt about using CTE instead of a view so that I can do it all as sql queries

However , adding the With part doesn't work with Access.

Is there anything that can be similarly done in Access (or should I be moving to a new thread?)

Thanks a lot in advance!