Update Query

  • Thread starter Thread starter Piggy
  • Start date Start date
P

Piggy

Hi,

May I know how can I update a column (ColumnA) in one
table (TableA) with the value of another column (ColumnB)
in another table (TableB)? The 2 tables can be link by
the column 'LinkID'.

Thank you
 
Piggy

update tableone set fieldone=(select fieldtwo from tabletwo where
tableone.linkID=tabletwo.LinkID)

this will work if there is one two oen relation between the table


Thanks
Sajeev
 
Back
Top