Alex Ezell wrote: > This query works fine, but the issue is that I am only returned > the columns in the Fieldmap table. I would like for the result to > have all the columns from both the Fieldmap and the MemberField > tables.
You need to tell the ORM to return both entities. By default, the ORM will return the entity you are querying for, not additional entities, regardless of the query. You can do this by adding the additional entity you want to fetch using the Query object's `add_entity` method. The SQLAlchemy documentation has several useful examples of how to make use of `add_entity`. -- Jonathan LaCour http://cleverdevil.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---