3 ms·
This example seemed wrong to me as well. You can have a subquery, or CTE that returns as many fields as you want and can join on the manager key
by gerbler 5y ago
This example seemed wrong to me as well. You can have a subquery, or CTE that returns as many fields as you want and can join on the manager key
- kinjba11 5y agoAn additional subquery and a CTE are both restructuring the query significantly, which is the author's point.
- pjmlp 5y agoWell if he is insisting in doing the SQL version of writing everything inside a lambda without modularizing the code, then yeah that is bound to happen.
- gerbler 5y agoThere's already a subquery in there. I'm saying this can still be done with one subquery, just in a different place and it returns the desired results.