I have 2 tables: Match and Team.
Match(matchID is primary key, team1, team2, ...)
Team(TeamID is primary key, ...)

I mean how to force team1 and team2 is different from each other.
Ex: We won't want to see: Brazil vs Brazil ^^

Any help is appreciated...

Recommended Answers

All 3 Replies

any help? 1 week goes by...

dude, provide much much more info than that or we can't help

Composite key?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.