Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Unanswered:

    hoe to see solution for this problem

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    CREATE TABLE games
    ( gamedate DATE NOT NULL
    , hometeam INTEGER NOT NULL
    , awayteam INTEGER NOT NULL
    , CONSTRAINT hometeam_fk FOREIGN KEY ( hometeam ) REFERENCES teams ( id )
    , CONSTRAINT awayteam_fk FOREIGN KEY ( awayteam ) REFERENCES teams ( id )
    , PRIMARY KEY ( gamedate,hometeam,awayteam )
    , homescore SMALLINT NOT NULL DEFAULT 0
    , awayscore SMALLINT NOT NULL DEFAULT 0
    )
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    It would help if you told us what the problem is. The two references are not a problem.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by beilstwh
    The two references are not a problem.
    they are if you've never done it before

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What error or you getting that stops you from running your create script. I was NOT knocking your ability, i was asking what the problem is?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •