> -Original Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: Wednesday, August 25, 2010 2:06 PM
> To: Travis Ard
> Cc: [MySQL]
> Subject: Re: Calculating table standings
>
> Travis
>
> Do you think it would be better if I stored t
it is too awkward to
query this table twice and union the results, then you might want to add a
summary table.
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 2:06 PM
To: Travis Ard
Cc: [MySQL]
Subject: Re: Calcula
Travis
Do you think it would be better if I stored the information in
a separate table, rather than using unions etc - to make the searching,
counting etc easier ? Or is this method a standard way of dealing with this
sort of data.
Cheers
Neil
On Tue, Aug 24, 2010 at 5:43 PM, Travis Ard wrote:
Travis
Thanks for the response. Do you recommend I store the data in this way ?
Or should I look at storing in a separate leagues table, why by I list all
the data in the separate columns for each round and then just compute a
fairly basic query ? What is the recommend way ?
Cheers
Neil
On Tu
I think your match table has all the information necessary to display the
results you want. Since each record contains data for two teams (home and
away), you'd probably need to select each separately and union the results
together before summarizing. Your query might look something like the
foll