W dniu 18.01.2018 o 19:58, Richard Hipp pisze:
Try it this way:
SELECT * FROM card WHERE (statNumber,question) IN
(VALUES(2211,'psuc sei'),(2542,'kontynuowac'), (1449,'wymrzec'));
Thanks. This works (with spelling fixes).
I am open to enhancing the syntax here, but not right now becau
estion) in ((2211, 'psuć się'),
(2542, 'kontynuować'), (1449, 'wymrzeć'))
Works:
select * from card where (statNumber, question) in (select statNumber,
question from card)
Why?
thanks and best regards
Szyk Cech
__
2 matches
Mail list logo