[sqlalchemy] Joining three tables - Selecting column from two different tables

[Steve]

Hi all,

Newbie here.

I just want to execute the following sql using SqlAlchemy . But
getting various errors.

select ssf.factor,ssf.displayname,pmw.weight
from probability_models_weights pmw
inner join probability_models pm on pm.id = pmw.model_id
inner join success_factors ssf on ssf.id = pmw.factor_id
where pm.id = 6

I want to execute this using session.

I am using declarative base with the following auto loaded classes.

class SucessFactors(WBase):
    __tablename__ = "success_factors"
    __table_args__ = {'autoload':True}

class ProbabilityModels(WBase):
    __tablename__ = "probability_models"
    __table_args__ = {'autoload':True}

class ProbabilityModelsWeights(WBase):
    __tablename__ = "probability_models_weights"
    __table_args__ = {'autoload':True}

I tried the following but it didn't work.

session.query(SucessFactors.factor,SucessFactors.displayname,ProbabilityModelsWeights.weight).
\
        join(ProbabilityModelsWeights,ProbabilityModels,
ProbabilityModelsWeights.model_id == ProbabilityModels.id).\
        join(ProbabilityModelsWeights,SucessFactors,
ProbabilityModelsWeights.factor_id == SucessFactors.id).\
        filter(ProbabilityModels.id == model_id).\
        all()

Thanks in advance.

Steve.

-- 
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 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.