Graphics

Hi,

I'm doing a scoreboard and using a SQL query on my datalinq:

"SELECT * FROM Group A ORDER BY Pts DESC"

This being a sports scoreboard, sometimes the Pts column will give you a tie(two teams have the same number of Pts). When this happens I want to be able to sort by Goals column. A quick SQL query search will tell you that this is possible with the following syntax:

"SELECT * FROM Group A ORDER BY Pts DESC, Goals DESC"

However this query doesn't seems to work in XP. Any ideas to why? I've tried using different column names and values, and writing the query in a number of ways.

I used this query in datalinq and it worked ok for me:

`SELECT * FROM ROSTER ORDER BY WEIGHT DESC, JERSEY DESC`

What type of data source are you using? Is it a database or Excel? Could you send a link to your datasource for me to try?

#XPression

I think if your table name has spaces in it you need to enclose it in square brackets like this:

`SELECT * FROM [Group A] ORDER BY Pts DESC, Goals DESC`

#XPression