The numbers in the ORDER statement are the cardinal positions of the columns in the SELECT statement required for ORDER.
Have you checked if there is a View named "Person@Reliance"? Adrian J. Moreno I Know Kung Foo Consulting (214) 280-6676 http://iknowkungfoo.com http://twitter.com/iknowkungfoo Sent from my iPad On Jun 13, 2011, at 12:08 PM, Michael Dinowitz <[email protected]> wrote: > > I'm looking at a query in someones code and it has something that is > unfamiliar to me. The select statement has: > FROM dbo.Person@Reliance > > What is the @ sign? Neither Person nor Reliance are tables in the database. > > Also, there is an Order By that just has numbers, no fields to sort by: > ORDER BY 8,9,6 > > Can anyone educate me on this? > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > 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:3409 > Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3414 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
