Avoid creating all the sub queries separately
There are some tables that I would like to join. The tables are ten some of them are "static" and some of them are sub queries that I shall use fly Access SQL to create.
These are some of the considerations that I would like to be affected. I do not want to avoid having a huge block of a code and I would also like to make positive improvements on the design. Finally I want to avoid creating all the sub queries separately, saving them as tables and then creating a more direct join.
This is not the first time I am doing this for I have previously created a huge SQL query that was functioning well apart from the errors underlined in the considerations above.
I want to start a fresh and I am seeking assistance from you to enable me do this.