View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 07:54 AM
Mahesh S
 
Posts: n/a
Default How to do a sql update based on a join?

Hi

I have to perform an update on a table. I am having problems figuring
out how to join two tables as I need to check a value in a different
table before performing the update.

I have two tables here

Table1
ID TIMESTAMP

Table2
ID Value

I would like update value in table2 based on the timestamp?

Any help appreciated?

Thanks
Mahesh

Reply With Quote