On Jun 9, 2013, at 8:06 PM, Michael Bayer <mike...@zzzcomputing.com> wrote:
> > SELECT items.id AS items_id, items.item_type AS items_item_type, > items.parent_id AS items_parent_id, items_ext.id AS items_ext_id, > items_ext.custom_name AS items_ext_custom_name, items_1.id AS items_1_id, > items_1.item_type AS items_1_item_type, items_1.parent_id AS > items_1_parent_id, items_ext_1.id AS items_ext_1_id, items_ext_1.custom_name > AS items_ext_1_custom_name > FROM items LEFT OUTER JOIN items_ext ON items.id = items_ext.id LEFT OUTER > JOIN (items AS items_1 LEFT OUTER JOIN items_ext AS items_ext_1 ON items_1.id > = items_ext_1.id) ON items.id = items_1.parent_id > please let me know if MySQL is still impacted by the parenthesis, x LEFT OUTER JOIN (y LEFT OUTER JOIN z). If the string of joins have all the same "outerness", they can be flattened out at compile time as well with a join rewriting scheme. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.