On Tue, Oct 21, 2003 at 10:36:01PM -0700, kandadai prasanna wrote: >Dear friends, > >how to update one table using another table. > >We have written the following query: >table1 - hrcoil >table2 - pipemaster > >update pipemaster,hrcoil set >pipemaster.heat1=hrcoil.heatno where >pipemaster.unic1=hrcoil.unicno
update pipemaster set pipemaster.heat1=hrcoil.heatno from pipemaster,hrcoil where pipemaster.unic1=hrcoil.unicno; Peace -- Rajesh : ####[ GNU/Linux One Stanza Tip (LOST) ]####################### Sub : Corrupt .tar.gz downloads with Netscape LOST #249 Tarballs downloaded with Netscape at times seem to give error during untarring. Some versions of Netscape (4.7x) do gunzip on the fly, and what is saved is a .tar file (though the name is still retained as .tar.gz). Doing a "file download.tar.gz" can elucidate the problem ... 'tar -xvf' usually works. ####[bish (at) nde.vsnl.net.in]############################### : ------------------------------------------------------- This SF.net email is sponsored by: The SF.net Donation Program. Do you like what SourceForge.net is doing for the Open Source Community? Make a contribution, and help us add new features and functionality. Click here: http://sourceforge.net/donate/ _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
