Jump to content


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


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..



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.