update a table from another table

Giganews Newsgroups
Subject: update a table from another table
Posted by:  iccsi (inun…@gmail.com)
Date: Mon, 17 Oct 2011

I want to update my table 1 from table2 and have following data

table1

MyID MyData1  MyData2
  1      A            C
  2      B            C
  3      H            F

table2

MyID1  MyData3    MyData4

  1        G              C
  2        H              C

I want to update table1 all MyData2 are "C"  to MyData2 data.
I tried to look the UPDATE statement, but can not find anything to do
the update.

Your help is great appreciated,

iccsi

Replies