Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: brianism
My query should return 5 rows of data. Right now my results show nothing.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:Well, you are seeing symptoms of why it is bad, that being the fact that it isn't easy to write a query with a simple join to get the team names. Lets say that instead of having seperate columns for each team in the teamchallenges table that you instead have an intermediate table named challenges2team where you had only 2 columns named teamID and challengeID. Then your teamchallenges table would only contain information directly related to challenges, such as id, compname, and your challenges2team would contain a row for every matching teamID and challengeID.
I'm not sure why the data model is bad.
Copy link to clipboard
Copied
Copy link to clipboard
Copied