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 JABE's comment (which is the right answer):

 

I'd change your first WHERE to:

SELECT * FROM tblworker WHERE priority IS NOT NULL

instead of

SELECT * FROM tblworker WHERE NOT priority IS NULL

 

It's more readable and it's what's recommended.

 

Also, there's a Database forum where you might get more help than Windows Forms for SQL questions :)

 

-Ner