I need a query that will search all the rows and columns in a particular table. The Table has the following columns:
Sport1
Team1
Score1
OpScore1
Sport2
Team2
Score2
OpScore2
Sport3
Team3
Score3
OpScore3
Sport4
Team4
Score4
OpScore4
The sport and team data all come from the same table so sport1 and team1 might be the same as sport3 and team3 in the same row or in different rows. I need to be able to search the table for all the teams that dont have a score posted in the corresponding score column. The idea is to make it easy to update all the scores.
Sport1
Team1
Score1
OpScore1
Sport2
Team2
Score2
OpScore2
Sport3
Team3
Score3
OpScore3
Sport4
Team4
Score4
OpScore4
The sport and team data all come from the same table so sport1 and team1 might be the same as sport3 and team3 in the same row or in different rows. I need to be able to search the table for all the teams that dont have a score posted in the corresponding score column. The idea is to make it easy to update all the scores.