|
Check this thread: http://archive.midrange.com/rpg400-l/200702/msg00415.html Celebrating 10-Years of SQL Performance Excellence -----Original Message----- Subject: SQL Update for multiple fields I wanted to do this, which is acceptable in TSQL, but apparently not on the iSeries: update csship set fpl1tx = b.ADDR1, fpl2tx = b.SUITE, fpl3tx = b.ADDR2, fpl5tx = b.STATE, fpoocd = b.ZIP, fpcncd = b.COUNTRY from csship as a, qasship as b where a.fpcomp = b.comp and a.fpjynb = b.cust and a.fpjxnb = b.ship Is my only alternative to do a subquery for each one of the fields ? Seems like there ought to be a simpler way. Let me know if I'm missing something. Thanks Greg Fleming
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.