I've had this problem many, many times. And it's always turned out to be a small typo or "" around an integer, but I just cannot find what's wrong with my SQL Statement this time!
SELECT Card_ID FROM Payment WHERE Customer_ID = 12 AND Card_Number = 1231231231231231
The table and fields are named correctly (the table is actually a query).
The only thing I can think of is the card number being too large, however it works fine in my INSERT INTO statement!
All of the fields are formatted as their respective data types, ie. Integers are set to integer, not string.
Any help is much appreciated!