If I want scores information for just my alliances (not the opposing alliance) I have to do two queries.
One for the scores for my team and another to SCHEDULE or MATCHES so I can cross reference what my alliance side was for
 a specific SCORE record.
It would be unnecessary to do this if the team numbers were on the returned SCORE records.