I'm trying to update a table in one database with data from a table in
another database on the same server, but I'm having trouble with my naming
convention.
Here's the script:

Hi Expert,
I came across a situation where the query result returns all non-NULL
records even I use TOP 1 statement.  Here is  the SQL statement:
SELECT     CONTRACT_NUMBER, STEP, STATUS_END_DATE, CIS_PK

I run the script below in sql2005 and am receiving the error msg 209. Do I
need a prefix to  order by either STATE, TAXAMNT,  or SUBTOTAL because I want
them displyed in front.
Thank you.