at sign in sql select statement

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 <mdinowit@houseoffusion.com> 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