diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2009-04-28 11:05:28 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2009-04-28 11:05:28 -0400 |
| commit | 4424f988de4fe7f9a6e47117401db11409612570 (patch) | |
| tree | 3fd436b0d0eff217ce878cae73dd070a73f12835 /tests/join.ur | |
| parent | 37dd8d6d0f33b2a6370301f12287c8e15d17094a (diff) | |
LEFT JOIN
Diffstat (limited to 'tests/join.ur')
| -rw-r--r-- | tests/join.ur | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/tests/join.ur b/tests/join.ur index 30a0e744..74f49eec 100644 --- a/tests/join.ur +++ b/tests/join.ur @@ -1,8 +1,9 @@ -table t : { A : int } +table t : { A : int, B : string, C : option string } fun main () = r <- oneRow (SELECT * FROM t); r <- oneRow (SELECT * FROM t AS T1, t AS T2); r <- oneRow (SELECT * FROM t AS T1 CROSS JOIN t AS T2); r <- oneRow (SELECT * FROM t AS T1 JOIN t AS T2 ON T1.A = T2.A); + r <- oneRow (SELECT * FROM t AS T1 LEFT JOIN t AS T2 ON T1.A = T2.A); return <xml/> |