SQL syntax error

[z3dom]

I want to use such expression: SELECT orders.ID client FROM work.orders AS orders, work.base clients AS base clients WHERE orders.ID client = base clients.ID AND (orders.ID категории = 6 OR orders.ID category = 15 OR orders.ID category = 19 OR orders.ID category = 30 OR orders.ID category = 36) EXCEPT SELECT orders.ID client FROM work.orders AS orders, work.base clients AS base clients WHERE orders.ID client = base clients.ID AND orders.ID category = 36 AND orders.ID order state = 3

In two words: I need to get only that records from first SELECT which absent in second SELECT.

The problem is in word EXCEPT. Both SELECT expression is working good singly, but when I try to union it with EXCEPT operator there is a error:
“You have an error in your SQL syntax…near ’ EXCEPT SELECT…”

What is wrong??? I tried many different variants but no one is working.

[EasyTrieve]

a) Which data base are you using? b) When you have a space in a field name it must be quoted, e.g. "ID client", instead of ID client.

[z3dom]

a) I am using MySQL data base via connector.
b) All field names are quoted (this site’s engine transformed my expression after publication. Originally there are quotes everythere)

[Ratslinger]

Based upon you statement that both SELECT statements work independently, in Query using SQL mode, turn on Run SQL command directly by clicking on the SQL icon on the toolbar. The interpreter may not like EXCEPT.

[z3dom]

“run sql command directly” is turned on.

[Ratslinger]

MySQL does not support the ‘EXCEPT’ statement.

[z3dom]

Thank you! I didn’t know it. The problem was solved by this expression: SELECT … (SELECT…) T1 LEFT JOIN (SELECT…) T2 WHERE T2 IS NULL