scalar() works with outerjoin()?

[Dennis]

Does scalar() work with outerjoin()?

I have an outerjoin sql statement that will only return 1 row.

I used scalar(), but then I could not get the column values of the 2nd table.

I fixed it, but just wondering if scalar() and outerjoin() are not to be mixed in the same sql statement?

[Dennis Fogg]

oh, I found the function:  first()

which seems to work fine with joined queries.

--
You received this message because you are subscribed to a topic in the Google Groups "sqlalchemy" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlalchemy/si-gRQnxPWk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sqlalchemy+...@googlegroups.com.
To post to this group, send email to sqlal...@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.