Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
coorelated sub query with group by
I need to take off at the moment, but I'll check back and try to elaborate later. Notice the location of the subqueries in the example from earlier. The subquery set is after the FROM, not part of the SELECT. You can choose as many columns as you want when done this way. You're basically... -
coorelated sub query with group by
You had said the nested selects are 'hard-coded', but you have power to change the code, correct? I believe there's a fair amount you can do to make this code easier to handle... If you can change the code itself, I think we could make your life much easier. Is it safe to assume this is...
