Speeple News Search

Sign Up! | Tags | Domains | Statistics | Options | Advanced Search

Comment by Chris Eaton on INSERT, UPDATE, DELETE from a full select

ittoolbox.com » 2008 » May » 7th » Comment by Chris Eaton on INSERT, UPDATE, DELETE from a full select

Tagged: delete, db2, select, new feature

Hi Chris, I need some more context because in the statement you have not joined table B and table C so the database won't know what value you want from where. Perhaps if you put in here some example rows before the update from the two tables and some sample rows on what you want it to look like after the update then I can try to help you with the SQL. !***! Click here to Continue Reading »


Latest news from Comments on All ITtoolbox Blogs:

  1. Comment by NOCOPY on First Thoughts on Using Chrome
  2. Comment by Dan Morrill on Apple-can't-do-wrong-people annoy the crap out of me
  3. Comment by Veronica Stewart on Apple-can't-do-wrong-people annoy the crap out of me
  4. Comment by derek1058 on More on the Firefox hangups
  5. Comment by me on Attention to Detail Exercise

Latest news from ittoolbox.com:

  1. Deliverable: Work Facility Requirements
  2. Defining "Application Architecture"
  3. Enterprise Architecture and Financial Planning
  4. NYCBSDCon Registration and Schedule Up
  5. Simplify the SAP User Experience