Something like
Code:
SELECT Tourid, Match_Id, teamid FROM Tourid WHERE Tourid=1 AND Match_Id = 1 AND teamid = 1
UNION
SELECT Tourid, Match_Id, teamid FROM Tourid WHERE Tourid=1 AND Match_Id = 1 AND teamid = 2
The above assumes you care about the tour and match being the same for both teams, otherwise in subsequent years, you'll get records you don't want where the tourid is some other number but the team and match numbers are repeated. I have no idea how you want to provide those number to the query, so I just used #1 for example.
but you have two rows of 1,1,1,1 which doesn't seem right.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.