Avoid creating all the sub queries separately

Asked By ROBERT MILLER 0 points N/A Posted on - 11/08/2011

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.            

• Status: Open
• Question Views: 937
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Sybase Database

Answered By lee hung 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.

Regards
Lee Hung

 

 

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 11/30/2011
• Question Category: Sybase Database