SQL query using 2 keys

[ecom_guy]

Hi,

I am trying to display result using a sql query where sorting will be done simultaneously for both the keys.
I want the sorting to be done based on Year and Month separately.
But now when i run the query only 1 resultset (by year) is getting complied. Where i may be going wrong?

Thanks

[Dijkgraaf]

Can you show us your SQL?

[ecom_guy]

Hi,

The problem is solved. Needed to make sure that both the queries get excecuted in the same time. Earlier it was just excecuting the first part of the query.

Thanks