sql Statement

[William Thys]

SELECT * FROM tblworker WHERE NOT priority IS NULL ORDER BY priority
UNION
SELECT * FROM tblworker WHERE priority IS NULL

why does this code NOT work in SQL???????????
without the ORDER BY priority it does work!

 

[JABE]

Because ORDER BY is valid only on the last SELECT statement in a UNION.

 

[Nerseus]

In addition to JABEs comment (which is the right answer):

Id change your first WHERE to:
SELECT * FROM tblworker WHERE priority IS NOT NULL
instead of
SELECT * FROM tblworker WHERE NOT priority IS NULL

Its more readable and its whats recommended.

Also, theres a Database forum where you might get more help than Windows Forms for SQL questions

-Ner