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