Hi, Does the S-SQL syntax allow table aliases? I haven't come across examples, neither in the official docs nor the example list on sabraonthehill. This is what I mean: SELECT t.col FROM tbl t; -- Johann I'm not from the internet, I just work there.
Am 21.08.15 um 07:09 schrieb Johann 'Myrkraverk' Oskarsson:
Hi,
Does the S-SQL syntax allow table aliases? I haven't come across examples, neither in the official docs nor the example list on sabraonthehill.
This is what I mean:
SELECT t.col FROM tbl t;
yes see http://marijnhaverbeke.nl/postmodern/s-sql.html#as ... :from (:as 't 'tbl) ~jens
CL-USER> (s-sql:sql-compile '(:select t.col :from (:as table |t|))) "(SELECT t.col FROM \"table\" AS t)" On Thu, Aug 20, 2015 at 10:09 PM, Johann 'Myrkraverk' Oskarsson < johann@myrkraverk.com> wrote:
Hi,
Does the S-SQL syntax allow table aliases? I haven't come across examples, neither in the official docs nor the example list on sabraonthehill.
This is what I mean:
SELECT t.col FROM tbl t;
-- Johann
I'm not from the internet, I just work there.
participants (3)
-
Drew C -
Jens Teich -
Johann 'Myrkraverk' Oskarsson