Hello, I would like to know how to create multiple foreign key references to only one primary key value in a different table. What I'm trying to accomplish is something like this - I have two tables - Team and Match. A match is always played between two teams, so I would like to have two foreign keys that reference a Team primary key (an id). However I seem to have a problem doing this because I'm getting an error which you can see in the image included. How can I avoid this error or what should I be doing differently ? The error arises as soon as I add the Team2_id foreign key. Thanks very much for the help.
Service d'assistance aux clients par UserEcho