Avoid creating all the sub queries separately

Asked By 0 points N/A Posted on -

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.            

Answered By 75 points N/A #108297

Avoid creating all the sub queries separately


Hello Robert Miller,

The easier way for you to create your tables and all that you have said in the question will be for you to use the queries that you already created as samples that will help you in creating the ones that you need to create right now.

Starting from scratch may be good, but it going to take you a lot of time. The ones you created may be having some errors, but you can still use them and iron out those errors with the help of sample codes that you can get from the internet from SQL sites. So I will advise you to use the codes that you already have as samples.

Hope this helps.

Lee Hung



Login/Register to Answer

Related Questions