Re: Self-joins in ClojureQL

2011-08-12 Thread Zak Wilson
Update: CQL does in fact support self-joins. An example of the correct syntax is here: http://pastie.org/2356343 -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new mem

Self-joins in ClojureQL

2011-07-21 Thread Zak Wilson
SQL allows for self-joins of the form SELECT e.first_name AS 'Employee FN', e.last_name AS 'Employee LN', m.first_name AS 'Manager FN', m.last_name AS 'Manager LN' FROM employees AS e LEFT OUTER JOIN employees AS m ON e.manager =m.id I can't determine a syntax for the same in ClojureQL. The limit