Re: Database Design problem
From: Tim Ferguson <FergusonTG_at_softhome.net>
Date: Mon, 28 Nov 2005 20:55:22 GMT
Message-ID: <Xns971CD4EFCBA49garbleme4455656_at_80.5.182.99>
Date: Mon, 28 Nov 2005 20:55:22 GMT
Message-ID: <Xns971CD4EFCBA49garbleme4455656_at_80.5.182.99>
"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 - 21:55:22 CET