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!