Why writes about incorrect syntax near Order?

Question

SQL

Like a textbook example

(SELECT      dbo.PN1.date, dbo.PN2.mp_tn3, dbo.PN2.price, dbo.PN2.id
 FROM           dbo.PN1 INNER JOIN
                         dbo.PN2 ON dbo.PN1.id = dbo.PN2.mp_pn1
 WHERE       (dbo.PN2.mp_tn3 = 31457))
UNION
(SELECT      dbo.NO1.date, dbo.NO2.mp_tn3, dbo.NO2.price, dbo.NO2.id
 FROM           dbo.NO1 INNER JOIN
                         dbo.NO2 ON dbo.NO1.id = dbo.NO2.mp_no1
 WHERE       (dbo.NO2.mp_tn3 = 31457))
ORDER BY 1

UPD
forgot to specify Microsoft SQL 2000 + Access 2003 adp
UPD2
Sorry to bother you, the query worked.
It was a glitch of that piece which checks syntax.

Answer 1

ORDER BY sorting must be on an existing field

Answer 2

ORDER BY 1 - 1 is what? field name? ORDER BY dbo.PN1.date

Answer 3

(SELECT

Remove parentheses.

Answer 4

And if so?

SELECT *
    FROM (SELECT dbo.PN1.date, dbo.PN2.mp_tn3, dbo.PN2.price, dbo.PN2.id
              FROM dbo.PN1 INNER JOIN dbo.PN2 ON dbo.PN1.id = dbo.PN2.mp_pn1
              WHERE (dbo.PN2.mp_tn3 = 31457)
          UNION
          SELECT dbo.NO1.date, dbo.NO2.mp_tn3, dbo.NO2.price, dbo.NO2.id
              FROM dbo.NO1 INNER JOIN dbo.NO2 ON dbo.NO1.id = dbo.NO2.mp_no1
              WHERE (dbo.NO2.mp_tn3 = 31457)
         ) t 
    ORDER BY 1

Answer 5

Ubuntu 14.04 LTS x64
www.ubuntu.com/download/server

Answer 6

If the RAM is less than 3.3 gig, then it's better to set x32 to work faster.