UPDATE FROM ????

[mooki]

Im looking for a way to update one table from another
without specifying all the columns of the tables.

like : update tb1
set tb1.* = tb2.*
from tb2

somthing like that ? is there any way of doing it ? or i will have to write all columns ???

 

[shyamMelwani]

Why not delete all rows from tbl1 and then
... 'Insert into tbl1 select * from tbl2'.

since they seem to have the same structures.

 

[Cagliostro]

Hi
the syntax is
-----------------------
update tb1
set tb1.onerow = tb2.otherrow
from tb2
where
tb1.oneID = tb2.otherOrTheSameID
--------
in 'where' statement you may put many conditions.