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?