SQLite Forum

Error: no such column: x
Login
So "e" only exists inside the CTE definition of "maxes", you can't use it outside of that definition. You then go on to write a query that doesn't even use "maxes" in it anywhere.

Project_List AS a
and
ABT_Budget AS b

are the only two tables in your FROM clause, so what was the point of defining maxes in the first place if it's not used anywhere?

You're not even trying to references maxes itself or the fields of maxes, you're trying to reference one of the fields of one of the tables used to create maxes. So I'm not really sure what you're trying to do here.