Mercurial > urweb
comparison tests/join.ur @ 749:16bfd9e244cd
INNER JOIN
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Tue, 28 Apr 2009 10:11:56 -0400 |
parents | 5f9b9972e6b8 |
children | 059074c8d2fc |
comparison
equal
deleted
inserted
replaced
748:5f9b9972e6b8 | 749:16bfd9e244cd |
---|---|
1 table t : { A : int } | 1 table t : { A : int } |
2 | 2 |
3 fun main () = | 3 fun main () = |
4 r <- oneRow (SELECT * FROM t); | 4 r <- oneRow (SELECT * FROM t); |
5 r <- oneRow (SELECT * FROM t AS T1, t AS T2); | 5 r <- oneRow (SELECT * FROM t AS T1, t AS T2); |
6 r <- oneRow (SELECT * FROM t AS T1 CROSS JOIN t AS T2); | |
7 r <- oneRow (SELECT * FROM t AS T1 JOIN t AS T2 ON T1.A = T2.A); | |
6 return <xml/> | 8 return <xml/> |