cachobong Posted January 13, 2006 Share Posted January 13, 2006 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! Link to comment https://forums.phpfreaks.com/topic/3189-more-help-on-sql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.