Thanks a lot. Works great!
Small correction, aliases should be with 'db.' prefix:
u1=db.users.with_alias('u1')
u2=db.users.with_alias('u2')
db().select(db.jobs.description,u1.name,u2.name,
left=(u1.on(db.jobs.user1==u1.id),u2.on(db.jobs.user2==u2.id)))
On 17 Mar, 16:05, mdipierro <[email protected]> wrote:
> This should do it:
>
> u1=users.with_alias('u1')
> u2=users.with_alias('u2')
> db().select(db.jobs.description,u1.name,u2.name,
> left=(u1.on(db.jobs.user1==u1.id),u2.on(db.jobs.user2==u2.id)))
>
> On Mar 17, 9:48 am, ls1 <[email protected]> wrote:
>
> > Let's consider following tables:
>
> > db.define_table('users', SQLField('name'))
> > id1=db.users.insert(name='user A')
> > id2=db.users.insert(name='user B')
>
> > db.define_table('jobs',
> > SQLField('description'),
> > SQLField('user1',db.users),
> > SQLField('user2',db.users))
> > db.jobs.user1.requires=IS_IN_DB(db,'users.id','%(name)s')
> > db.jobs.user2.requires=IS_IN_DB(db,'users.id','%(name)s')
>
> > db.jobs.insert(description='some job to do', user1=id1, user2=id2)
>
> > Simple query like this will give me name of user1:
> > db(db.jobs.user1==db.users.id).select(db.jobs.description,
> > db.users.name)
>
> > Question: how to make query to show 'description' from table 'jobs'
> > together with names of the 2 users taken from table users?
> > something like: jobs.description user1.name user2.name
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
