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!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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) -
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...
