• Post Reply Bookmark Topic Watch Topic
  • New Topic

Why this SQL has error near the keyword BETWEEN

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
Thanks
Jack

 
E Armitage
Rancher
Posts: 989
9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!