Hi
My concern is about a Primary Key in two columns (integer values) which
I want type explicitly in my query (like in example "Not works"). My
example only shows problem and it is not real case (however database is
real).
Not works:
select * from card where (statNumber, question) 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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
