Viewing 3 posts - 16 through 18 (of 18 total)
It's happening in your subqueries. SQL is treating the value from the outer query as part of the SELECT so the aggregate rules apply. Will adding T1.LineNum to the GROUP...
January 13, 2020 at 5:31 pm
#3715006
Thanks! I am having so much fun being part of the community!
September 9, 2019 at 3:46 pm
#3678529
If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.
May 20, 2019 at 2:41 pm
#3645407