Jump to content


Photo

More help on SQL


  • Please log in to reply
No replies to this topic

#1 cachobong

cachobong
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 13 January 2006 - 04:06 AM

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!





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users