output group issue

[Guest]

Hi I have a small problem wit my cfoutput group

if you look at http://www.northsydneycc.com.au/EditMatchResult.cfm

you will see the output is grouped by season but this is being duplicted for some reason

i have this query below, if i take out the second inner join then it displays correctly, but i need this to show the teamname

any ideas how to sort this out

<CFQUERY datasource="Cricket" Name="GetResults">
SELECT MS.MatchDate, MS.Opponent, ST.SeasonYear, TN.TeamName
FROM matchresults MS

INNER JOIN seasontable ST
ON MS.Season = ST.SeasonID

INNER JOIN teamnames TN
ON MS.TeamID = TN.ID

ORDER By MS.MatchDate, MS.TeamID
</cfquery>

[BKBK]

Relate column seasonYear to order-by clause, since cfoutput groups by it.

[Guest]

ok yes done that but still i get duplicate seasons

[Newsgroup_User]

Have you checked your data to make sure there aren't duplicate rows?

--
Adam