league

Gil,

Try something like:

SELECT T1.TeamName, T2.TeamName
FROM tbl_Teams T1, tbl_Teams T2
WHERE T2.TeamName T1.TeamName

This should give you all of the required combinations of two teams (you will
need to change the table name and the TeamName fields to coincide with your
table structure).

HTH
Dale
--
Email address is not valid.
Please reply to newsgroup only.


"gil_wilkes" wrote:

How can I have a query that works out all the fixtures for all teams. All
teams have to play each other once. I have a table with just the team names
in it.