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 limitation, as I see it is with 'table', which does not support aliasing as far as I can tell. It can take a hashmap in place of a table name, but this doesn't emit the appropriate syntax for a self-join: 'AS' is missing. What is the real purpose of supplying a hashmap to 'table'? Is there a way to do a self-join? -- 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 members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en
