I have created a view (1), which extracts info from about 11 tables... this part works fine
The next thing I do is using a Group By, I break down the View (1) that I have created.
For the Group By, I have three different selections, and it all depends on which option the user selects, I will run a certain Group By.
At the moment I have other Views(2,3,4) which references the first view(1) and does the Group By. I have done it this way because I kinder don't know any other way to do this.
I know this is not the best way to do this type of SQL, but it works. SO!!!
I have a couple of questions about this way of doing the statements in this manner:
1. How fast is this way of doing this type of SQL? Referenceing views from views.
2. Is there a faster way?
3. Is there another way I could achieve the same result but with another method? Maybe with using less views...