I am a JavaDB/Derby user, yesterday I wrote a SQL that retrieves customer's bd 7 day prior alerts
Here is the code.
I am getting
Error code -1, SQL state 42X01: Syntax error: Encountered "BETWEEN" at line 13, column 26.
Any ideas why this would happen?
posted 3 years ago
Well, what is the intention of the BETWEEN in that SQL? If you read your SQL out it stops to make sense when you get to that BETWEEN.