Thanks for that, I think I should have made my question a little clearer,
(it works for what I was asking but not what I want it to do).
spec_names = join(species_table, species_names_table,
and_(species_table.c.rank=="species",
species_table.c.taxa_id==species_names_table.c.taxa))
mapper(Species,
On Jan 26, 2009, at 12:50 PM, Nathan Harmston wrote:
> Hi,
>
> I am currently trying to use an SQL expression as a mapped
> attribute. I have a table called species_table and a
> species_names_tables, there is a one to many relationship between
> them on species_table.c.taxa_id and species_
