oh, I found the function:  first()
which seems to work fine with joined queries.

On Mon, Feb 2, 2015 at 12:21 AM, Dennis <dennisf...@gmail.com> wrote:

> 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?
>
> --
> 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+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.
>

-- 
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.

Reply via email to