I am confused. What is the model. is a table? should'n b and c be the same table? I think you mean
db.define_table('team',db.Field('name')) db.define_table('match',db.Field('t1',db.team),db.Field('t2',db.team)) a=db.team.with_alias('a') b=db.team.with_alias('b') rows=db().select(db.match.ALL,a.name,b.name,left=[a.on (a.id==db.match.t1),b.on(b.id==db.match.t2)]) for row in rows: print row.a,row.b This generates: SELECT match.id, match.t1, match.t2, a.name, b.name FROM match LEFT JOIN team AS a ON a.id=match.t1 LEFT JOIN team AS b ON b.id=match.t2; Beat that SQLAlchemy! Massimo On Dec 10, 9:48 pm, DenesL <[EMAIL PROTECTED]> wrote: > billf, that works using db.executesql(). > I wonder what is the DAL equivalent. > > On Dec 10, 6:15 pm, billf <[EMAIL PROTECTED]> wrote: > > > in sql: > > > select * from matches a inner join teams b on a.team1_id=b.teams_id > > inner join teams c on a.team2_id=c.team_id > > > so that a.? is match data, b.? is team1 data and c.? is team2 data > > > On Dec 10, 10:47 pm, pedro <[EMAIL PROTECTED]> wrote: > > > > On 10 Dec, 23:35, DenesL <[EMAIL PROTECTED]> wrote: > > > > > > SELECT * FROM teams, matches WHERE matches.team1_id=teams.id AND > > > > > matches.team2_id=teams.id > > > > > If I interpret that correctly it means: look for all matches where a > > > > team played itself. > > > > Unless you are looking for wrongly entered match info it would not be > > > > very useful. > > > > After looking carefully to my query I came to that conclusion too. > > > _select() returns exactly the SQL statement I initially thought, > > > problem is that was incorrect. That is indeed not useful at all. > > > So this turns out to be a question about basic SQL, > > > How do I select all matches, from the matches table, and the teams' > > > names from the teams table? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---