Damien07/12/2021, 4:45 PM
I have my subselect working, have my column alias working, I can select by the alias (e.g.
select sum(subQuery.myCol + subQuery.myCol) from (select col as myCol) subQuery
). But I cannot figure out how to construct further functions from the aliased columns. I essentially have multiple aliased columns in a subselect and I wish to multiply them in some way and query the result. Appreciate any insight! No idea where to start (QueryBuilder?)
select subQuery.myCol from (select...)
. Not sure if there is a better way but it works so I'm happy!