[Ur] left join on same table?

[Adam Chlipala]

Adam Chlipala wrote:
> Marc Weber wrote:
>>    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>)

The other problem is that the SQL syntax extension only recognizes SQL 
keywords in all caps, so you need to change 'as' to 'AS'.