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 | 008b594412606bbf78fff76daff219a102ce2daa (patch) | |
| tree | 3fd436b0d0eff217ce878cae73dd070a73f12835 /tests | |
| parent | 04dd6b3727c7786a4824897e78b0b2982ecd6f5b (diff) | |
LEFT JOIN
Diffstat (limited to 'tests')
| -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/> |