Jump to content

Archived

This topic is now archived and is closed to further replies.

cachobong

More help on SQL

Recommended Posts

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!

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.