ST Alpha - "SQL help needed." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 167

SQL help needed.

Posted by Will Hunting (aka JoeMetz) Aug 17 '09, 09:16

I have a table, with Race_ID, Team_ID and Result as my three fields.

For what i'm doing, a crosstab query is *not* viable.

What I want is to make a subquery that gives me the basic outcome of

Team_ID --- Count of Wins --- Count of Losses.

Thoughts?

Responses:

sure - Beryllium Aug 17, 09:37
you have to program it in SQL, as opposed to taking to Access? nm -- nm - groiny Aug 17, 09:36 1
- I actually figured it out...in the MySQL language. - Will Hunting Aug 17, 09:38

Post a message top

SQL help needed.

Replies are disabled on threads older than 7 days.