Marc Weber wrote:
I tried copy pasting the example from the demos to try whether ur supports join on the same table:xml<- queryX (SELECT a.Id, a.A, b.Id, b.A FROM t1 as a LEFT JOIN t1 as b ON (a.id = b.id)) (fn r => <xml> </xml>) It seems it does not - I get messages that a (the alias name) is an unkown table. So is the only way generating such joins by using views ?
It's a much simpler problem than that. The local table names bound by 'AS' clauses are constructors of kind [Name], which means that they must begin with capital letters. (The 'AS A' syntax is shorthand for some Ur combinator application with an argument [#A].) Just change [a] and [b] to [A] and [B] and I think you'll see it working just as you expect.
_______________________________________________ Ur mailing list [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
