Massimo, Thanks for your reply, problem solved:
def byplace(): records=db((db.company.id==db.address.company)&(db.company.id==db.companyLOB.company)& \ (db.address.cityName=='Eindhoven')&(db.address.typeOfAddress==1)&(db.companyLOB.lineOfBusiness==1)) \ .select(db.company.companyName,db.company.ranking,db.address.streetName,db.companyLOB.lineOfBusiness, \ orderby=db.company.ranking|db.company.companyName) return dict(records=SQLTABLE(records)) >From your example I understand that it's like taking the Cartesian product and putting your join condition in the WHERE clause. Best regards, Annet. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---