What do your tables look like?
Steve
-----Original Message-----
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 2:43 PM
To: CF-Talk
Subject: (SQL) What is the proper way to do this?
A Sports Standings query.
Just using access for now. but basically I am using 4 access queries to
accomplish my standings calculation
1.) Calculate TeamName W L Pts GF GA for home games
2.) Calculate TeamName W L Pts GF GA for visitors
3.) Union the two tables
4.) Summarize and sort.
I am guessing that this could be easily done with 1 query doing it all.
What are other people doing?
http://www.rivercityhockey.net
Eric
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
