Thank you very much for the detailed answer. I now understand things better and
can better accept that they are how they are :-))
- Original Message -
From: R Smith
To: sqlite-users@mailinglists.sqlite.org
Sent: Wednesday, October 31, 2018, 21:34:30
Subject: [sqlite] use column alias
On 2018/10/31 9:21 PM, Simon Slavin wrote:
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
may I ask whether there is a deeper reason why using a column alias in the same
SELECT query doesn't work, e.g.
SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
> may I ask whether there is a deeper reason why using a column alias in the
> same SELECT query doesn't work, e.g.
>
> SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is that there's nothing in the SQL
3 matches
Mail list logo