join query:
feeds=db.query('select feeds.*,users.profilepic from
feeds* join users on feeds.userid=users.id *where userid in (select
friend_id from friends where myid=$userid) order by id desc limit
20',vars=locals())
select query: feeds=db.select('feeds',where='id=$i.id',vars=locals())
is there a way to use joins with db.select
thanks for any help
Paul
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" 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/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
