Mercurial > urweb

comparison tests/table.lac @ 221:79819a6346e2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fields in SQL expressions
author Adam Chlipala <adamc@hcoop.net>
date Sat, 16 Aug 2008 17:46:26 -0400
parents cc68da3801bc
children
comparison
equal deleted inserted replaced
220:2b665e822e9a 221:79819a6346e2
6 val q2 = (SELECT * FROM t1, t2) 6 val q2 = (SELECT * FROM t1, t2)
7 7
8 (*val q3 = (SELECT * FROM t1, t1)*) 8 (*val q3 = (SELECT * FROM t1, t1)*)
9 val q3 = (SELECT * FROM t1, t1 AS T2) 9 val q3 = (SELECT * FROM t1, t1 AS T2)
10 10
11 val q4 = (SELECT * FROM {t1} AS T, t1 AS T2) 11 val q4 = (SELECT * FROM {{t1}} AS T, t1 AS T2)
12 12
13 val q5 = (SELECT t1.A FROM t1) 13 val q5 = (SELECT t1.A FROM t1)
14 val q6 = (SELECT t1.B, t1.C, t1.A FROM t1) 14 val q6 = (SELECT t1.B, t1.C, t1.A FROM t1)
15 15
16 val q7 = (SELECT t1.A, t2.A FROM t1, t2) 16 val q7 = (SELECT t1.A, t2.A FROM t1, t2)