hello, I'm having difficulty making restrictions to a left outer join. I have these tables: Item: name Sale: name, user, price
I want to select all the items with the prices of any sales for the current user. For example, given this data: Items: apple banana orange Sales: apple,bob,1 apple,bill,0.5 orange,bob,3 For bob I want to show: apple,1 banana, orange,3 To do the left join I use: db().select(db.item.name, db.sale.price, left=db.sale.on(db.item.name == db.sale.name)) Is there a way I can restrict this query to join for just a certain user? thanks, Baron --~--~---------~--~----~------------~-------~--~----~ 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 web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
