when you do outerjoin() it will try to join from the first item in the list, unless you do select_from:
query(literal(), X.foo, Y.bar).select_from(X).join(Y, ....) will see what can be done about the error message On Mar 17, 2014, at 2:58 PM, Ryan Kelly <rpkell...@gmail.com> wrote: > Hi: > > When I run the attached example, I get the following error: > > sqlalchemy.exc.NoInspectionAvailable: No inspection system is > available for object of type <type 'NoneType'> > > Which is a result of "literal(1)" appearing first in the select list. > I don't particularly care than I can't order my columns that way, but > the error message cost me about 30 minutes just trying to figure out > why. > > Not sure if there is a good way to fix this or what the correct approach is. > > -Ryan Kelly > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > <t.py> -- 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. For more options, visit https://groups.google.com/d/optout.