diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2009-04-28 11:14:24 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2009-04-28 11:14:24 -0400 |
| commit | 5fbeb0e08f7c823115e33fb19071294037660ae2 (patch) | |
| tree | 462c19c00c540828ba796762b20a4f9eff691726 /tests/join.ur | |
| parent | 4424f988de4fe7f9a6e47117401db11409612570 (diff) | |
RIGHT and FULL JOIN
Diffstat (limited to 'tests/join.ur')
| -rw-r--r-- | tests/join.ur | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/tests/join.ur b/tests/join.ur index 74f49eec..d6647877 100644 --- a/tests/join.ur +++ b/tests/join.ur @@ -6,4 +6,6 @@ fun main () = 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); + r <- oneRow (SELECT * FROM t AS T1 RIGHT OUTER JOIN t AS T2 ON T1.A = T2.A); + r <- oneRow (SELECT * FROM t AS T1 FULL JOIN t AS T2 ON T1.A = T2.A); return <xml/> |