On 10/28/2011 4:28 PM, Pete wrote:
I have another variation of this issue:
SELECT col1 - col2 as Total, Total * price FROM tst
... gives an error " no such column: Total". I can just repeat "col1 - col2"
of course, but wondering if there is a way to refer to Total within the
SELECT.
This is by design, blessed by SQL-92 standard. The closest you can get
is something like
SELECT Total, Total * price FROM
(select col1 - col2 as Total, price from tst);
This will likely be noticeably slower though.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users