More help on SQL

[cachobong]

Hi guys! agen i need ur help!

 

Update columns in TMP_TABLE where in the condition holds a relation between CUSTOMER.name equates to TMP_TABLE.name.

 

How do i do this with one SQL statement?

 

columns in TMP_TABLE and CUSTOMER are :

name varchar(32), primary key

address varchar(64)

state char(2)

zip char(5)

tel char(10)

remarks varchar(64)

 

it's like copying a CUSTOMER table to TMP_TABLE but TMP_TABLE is not blank.

 

pls help..

thanks!