On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote: > Is there any way to update table values based on values in another table? > > For instance, given: > <table (column1,column2..)> > Table 1 (jobid, jobname) > Table 2 (person, jobid, jobname) > > could I update Table 2, setting jobname=Table1.jobname where > Table1.jobid=Table.jobid? Is it possible to do this in one SQL command, > so that SQL matches the updating set to the stored set?
UPDATE Table1, Table2 SET Table2.jobname=Table1.jobname WHERE Table2.jobid=Table1.jobid; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
