feeds=db.select('feeds.*,users.profilepic', FROM='feeds,users',
JOIN='feeds.userid=users.id',WHERE='id=$i.id',vars=locals())
doesnt work either
On May 1, 1:02 am, "paul jobs" <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
