Thread has been deleted
Last comment
What is wrong with this query? imgur.com/a/iu1u0gU
2019-04-06 14:32
hltv has 30 IQ, we can't fix this
2019-04-06 14:32
There are a few programmers here, and this should be pretty basic.
2019-04-06 14:34
#2
 | 
Portugal wiseGOD 
Stackoverflow Im on phone and can't really see the querys well. Just Google it and you'll find the help you need on stackoverflow.
2019-04-06 14:34
HLTV faster
2019-04-06 14:34
#6
 | 
Portugal wiseGOD 
Can you reply to me the CREATE command of the table where you've got the error?
2019-04-06 14:46
I added two images to the previous imgur showing the creation of the tables and its print out. (imgur.com/a/iu1u0gU) I can query transactions and the codes. I can also query using hard coded codes like E1100, but as soon as I use ANY it doesn't work anymore.
2019-04-06 14:53
#10
 | 
Portugal wiseGOD 
ANY is not an SQLite operator. Thats the problem. Use IN instead.
2019-04-06 14:57
Indeed, using IN worked. Thanks.
2019-04-06 15:03
#5
 | 
Palestine FREE_PALESTINE 
im think single quotes men?)
2019-04-06 14:37
You're probably missing a logical operator between your subqueries on that last query.
2019-04-06 14:52
NVM, just replace = ANY with IN operator
2019-04-06 14:56
#11
 | 
Portugal wiseGOD 
Yap. Im SQLite the ANY operator does not exists.
2019-04-06 15:00
Indeed, using IN worked. Thanks.
2019-04-06 15:03
Login or register to add your comment to the discussion.