SQL to update a column using another table

[James4099]

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.

 

[BarkingFrog]

UPDATE DDT4ENVR.CCR
SET USML_IND = (SELECT USML_IND FROM DDT4ENVR.THR WHERE USML_IND = 'Y')

 

[r937]

BarkingFrog, your subquery will return one or more instances of 'Y' -- one for every row in the DDT4ENVR.THR which has USML_IND='Y' -- and if it returns more than one, then the UPDATE fails on a syntax error

that surely isn't right

james, what are you trying to do?

r937.com | rudy.ca

 

[James4099]

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.

 

[r937]

jim, i understand you want to update one table from the other

what does "if I have more then one to update I can't used SQL to do it" mean?

do both tables have a field called USML_IND?

how do you want to match up the rows?

can you give a few rows of sample data from each table and show how the update should work?

r937.com | rudy.ca

 

[88777]

hi,

How do i use sql to create table of values?

 

[JarlH]

88777,

1. CREATE TABLE
2. INSERT values


You can check out this site to learn the basics:

http://sqlzoo.net/