Invalid completion of the SQL statement
There is a request SELECT * FROM SMSPECREFUSE WHERE REASON= 'Недопоставка'
It works correctly and outputs what you need.
If I add to the request SELECT * FROM SMSPECREFUSE WHERE REASON= 'The failure to deliver', 'Excess application', 'Mismatch price', 'No request', 'Marriage', 'item Exchange', 'Short time', 'Failure to follow orders', 'not ready for public consumption'
at the end of the error:
1
Author: Илья Евтропов, 2020-02-27
1 answers
SELECT * FROM SMSPECREFUSE WHERE REASON IN (
'Недопоставка', 'Превышение заявки', 'Несоответствие цены',
'Нет в заявке', 'Брак', 'Обмен товара', 'Короткий срок',
'Невыполнение заказов', 'Нетоварный вид'
)
SELECT * FROM SMSPECREFUSE WHERE
REASON = 'Недопоставка' OR
REASON = 'Превышение заявки' OR
...
1
Author: Igor, 2020-02-27 14:08:18