• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is wrong with this update statement?

 
Steve Watson
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to insert data with the following:



and I get an Oracle invalid identifier error.
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's this secret JOIN you have going on about?
 
Steve Watson
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, I left out last and, should be:

 
R. M. Menon
Author
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Steve Watson:
Sorry, I left out last and, should be:



You seem to be refering to "DELIVERY_HANDLING_UNIT_ITEM" as a table but iy is not the one being updated? Can you give the exact error and also give what you are trying to do?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic