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 strongm 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. James4099

    SQL to update a column using another table

    I'm trying to update Table DDT4ENVR.THR from Table DDT4ENVR.CCR. So if I have more then one to update I can 't used SQL to do it. I'm trying to select all (USML_IND that = 'Y' and update Table DDT4ENVE.CCR with the same data. I do appreciate all the help that you can give me on this problem. Jim.
  2. James4099

    SQL to update a column using another table

    I would like to know if you can update Table(A) from Table(B). My Sql is: UPDATE DDT4ENVR.CCR SET USML_IND ='Y' WHERE USML_IND 'b' (SELECT USML_IND FROM DDT4ENVR.THR WHERE USML_IND = 'Y') Thanks.

Part and Inventory Search

Back
Top