SQLite Forum

Question about aliases on SELECT
Login

Question about aliases on SELECT

(1) By doug (doug9forester) on 2020-06-02 00:32:47 [link] [source]

Given this select:

SELECT t1.a AS a1 FROM t1 AS ta WHERE t1.a = ...

I sort of expected an error, because I should have coded the WHERE as:

SELECT t1.a AS a1 FROM t1 AS ta WHERE ta.a1 = ...

But no error. Can I assume that both forms of WHERE are valid and yield the same results?

(2) By Keith Medcalf (kmedcalf) on 2020-06-02 03:24:50 in reply to 1 [source]

In this case, yes, because you have no ambiguities.

Consider:

select t1.a as a1 from t1 as ta, t1 as tb, t1 as tc where t1.a = 47

To which t1.a does t1.a refer?