just a guess, but could @name be a machine name? saying the table is on machine reliant? George > To: [email protected] > Subject: Re: at sign in sql select statement > Date: Mon, 13 Jun 2011 13:18:34 -0400 > From: [email protected] > > > 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:3411 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
