How to update one table depending on another table

cy163 · #1 (**permalink**) 12-18-08, 21:25

Hello ALL,

I have the two tables;

Code:

t1
DocID  Word   TitleWord  
1         book      0
1         read       0
1         open       0

2         computer 0
2         book        0

3         paper       0
3         desk        0



t2
DocID   Word     Tag
1          book      noun

2          computer   noun

I would like to update the t1.TitleWord field according to the table t2.

Code:

t1
DocID  Word   TitleWord  
1         book      1
1         read       0
1         open       0

2         computer 1
2         book        0

3         paper       0
3         desk        0

I want to use the following statement

Code:

UPDATE t1, t2

  SET  
         t1.TitleWord = '1'
WHERE
       t1.DocID = t2.DocID  AND t1.Word = t2.Word

I wonder if this statement is correct.

healdem · #2 (**permalink**) 12-19-08, 03:11

Quote:

Originally Posted by cy163

...I wonder if this statement is correct.

I dunno
why not try it and find out, and save the 6..12 hour delay?

cy163 · #3 (**permalink**) 12-19-08, 10:35

healdem, thanks.

I have tried with this statement and it worked well. However, I am not sure. Hence, i post it here to get comments.

healdem · #4 (**permalink**) 12-19-08, 11:16

well if it works it works
or is the question
I've tried this, but is there a better solution?

galih · #5 (**permalink**) 01-04-09, 09:48

UPDATE t1
SET TitleWord=1
where DocID=1 AND Word="book"

UPDATE t1
SET TitleWord=1
where DocID=2 AND Word="computer"

Internet Services

Web Development

Digital Marketing

Consumer Tech