Why is it called SubQuery1 when it’s not a “sub” query. It’s the first query?
I find it unnessesarily confusing.
3 Likes
If I had to guess, it’s because you can change the type to “Inner” or “Union” etc., and it becomes a subquery. The first “subquery” created is not necessarily the main / top level query. Easier to set them to SubQuery1, SubQuery2, etc. than to try to figure out what you’re doing and possibly rename them itself.
2 Likes
Also, don’t let yourself be bothered. You can type whatever you want in there
2 Likes
Yeah I see them all as subqueries, and the difference is what you set as the query type (Top, Inner, etc.) Don’t expect nomenclature to make any sense in Epinetic.
1 Like
Yep “subquery” isn’t technically a thing in T-SQL. And why does BAQ work in a way that mismanges cache so hard? Why start at 1 instead of 0?
To be fair those are the two hardest problems in programming.
1 Like
The hardest thing in programming is naming things (variables, functions, file names, etc…)
1 Like