|
|
|
|
What happens if you try this:
update mydb.table1 t1 set t1.name = (select t2.name
from mydb.table1 t1, mydb.table2 t2 where t1.id = t2.id);
I don't think the dot versus slash matters here. I do the slash in STRSQL
and the dot in JDBC all the time.
Larry W. Loen - Senior Linux, Java, and iSeries Performance Analyst
Dept HP4, Rochester MN
This mailing list archive is Copyright 1997-2007 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact .
