> SELECT * FROM teams, matches WHERE matches.team1_id=teams.id AND > matches.team2_id=teams.id
If I interpret that correctly it means: look for all matches where a team played itself. Unless you are looking for wrongly entered match info it would not be very useful. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
