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;
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.
postmodern-devel@common-lisp.net
-
Drew C -
Jens Teich -
Johann 'Myrkraverk' Oskarsson