Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eaglei22

    DB2 Update coolumn based off of results from join?

    Got it to work this way finally (and after pulling most of my hair out) UPDATE B SET status = "CLS" WHERE ORDERNO IN (SELECT b.ORDERNO FROM A a, B b WHERE a.ORDERNO = b.ORDERNO)
  2. eaglei22

    DB2 Update coolumn based off of results from join?

    I have two tables, A and B. I am trying to update a status field to, "CLS" only if there are two matching rows found between A and B.. I am stuck trying to do this in DB2. I have tried, UPDATE B SET status = "CLS" WHERE ORDERNO = (SELECT b.ORDERNO FROM A a, B b...

Part and Inventory Search

Back
Top