I have 3 tables:
1. tblSports which has an ID and Sport columns (basketball, baseball,
football, and volleyball)
2. tblTeams with an ID and Team columns (TeamsA to D)
3. tblJoin which has two foreign key columns (ID for Sports, ID for
Teams) This is where teams are joined to whatever Sports they play.
Questions:
1. How should I do my select statement when given the team
it'll show the sports they do NOT play?
2. Just the opposite of the 1st. Given the sport, what teams do NOT
play?
Thanks in advance for your help.
Marvin