hihi all,
my apologies i realize my question is not restricted to struts per se,
but i'm hoping to get help from the many experts here...
is there an ansi sql compliant way (ie. i'm using jdbc) to update many
columns in a table with values from another table without using a
subquery for each column being updated?
ie. i want to avoid this:
update tableA
set a = (select...),
b = (select...),
c = (select...)
where
id = 1
each column is being updated from the same other table (it would be
same record in fact), not from many other different tables.
surely, someone has faced this situation? i hope?
please and thanks,
woodchuck
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
