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