Re: Database Design problem

"paulhutchings7204" <paul_hutchings_at_blueyonder.co.uk> wrote in news:1132848500.303575.282710_at_z14g2000cwz.googlegroups.com:

> My dilemma is I
> have a TEAM table and the relationship to the fixture table is that of
> many to 2 (2 teams in a fixture a fixture have many teams.....)

  create table fixtures (
    matchnumber sometype,
    hometeam sometype references teams,
    awayteam sometype references teams,
    isonneutralground bit,
    dateoffixture datetime,
    result shorttext,
    etc etc
  )

Tim F Received on Mon Nov 28 2005 - 14:55:22 CST