On Sat, 29 Mar 2003, shreedhar wrote:
> Using this query I am expecting result as
>
> year month totalreported closederrors openerrors fixederrors
> 2002 1 31 29 2
>
> 2002 2 85 60 25
>
> 2002 3 16 12 4
> 2002 5 41 29 12
> 2002 7 48 48
> 2002 8 1 1
> 2002 10 51 51
> 2002 11 69 15 54
> 2002 12 8 8
>
> 2003 1 9 9
>
> 2003 2 38 38
>
>
>
> But Retreiving result as
>
> year month totalreported closederrors openerrors fixederrors
> 2002 1 31 29 2
> 2002 1 31 29 9
> 2002 2 85 60 25
> 2002 2 85 60 38
> 2002 3 16 12 4
> 2002 5 41 29 12
> 2002 7 48 48
> 2002 8 1 1
> 2002 10 51 51
> 2002 11 69 15 54
> 2002 12 8 8
> 2003 1 9 29 2
> 2003 1 9 29 9
> 2003 2 38 60 25
> 2003 2 38 60 38
>
>
>
> I mean I values retreives across years data is repeating.
>
> May I know how can I get expected results by above query.
Hmm, what version are you using and what are the definitions of the tables
and what do the component subselects generate? I don't see anything
obviously wrong (although I'd think that the distinct clauses are
unnecessary with the group by), so I could have missed something or you
could be hitting a bug, but without something to plug in to try with it's
hard to tell.