[Ur] left join on same table?

Marc Weber marco-oweber at gmx.de
Sat Dec 11 19:59:26 EST 2010


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 ?

Marc Weber



More information about the Ur mailing list