• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Why Table Alias doesn't work for Derby?

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


java.sql.SQLSyntaxErrorException: Column 'O.PURCHASEDATETIME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'O.PURCHASEDATETIME' is not a column in the target table.
This is as simple as can be. Derby still cannot understand me.
Why
Thanks
Jack
 
Ravi Sree
Ranch Hand
Posts: 64
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why dont you post the table design too?
Try this and check:


I think this should work.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic