Never seen @ in a table name either, dunno what that might mean.
However, the numbers in ORDER BY relate to the columns in the SELECT part:
SELECT id,name,email
...
ORDER BY 3,2
...is equivalent to...
SELECT id,name,email
...
ORDER BY email,name
You can also use numbers in GROUP BY in the same way.
Useful when you want to avoid repeating a bunch of column names ... though less
helpful when you've got nine (or more) columns and you're ordering like they
are in your example.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3410
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
