×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I want to update keywork7 column from another joined table. I want to update ONLY after comparing one column from one table to one column from the second table (as shown below at Error1).
How can I accomplish this in SQL?
The code below throws an error: Column SEAL1 not in specified tables.
Thanks!
update jstone/docs00
set keyword7 =
(select seal1 from load
where ashpnbr = substr(keyword1,1,10)
and shipdate =
'20'||substr(keyword2,7,2)||substr(keyword2,1,2)||
substr(keyword2,4,2) )
where
substr(keyword7,1,10) <> seal1 <------Error1: how to compare one column from each table
and substr(keyword7,1,6) = substr(seal1,1,6)
and substr(keyword2,7,2) = '14' -- only fix 2014 records
and docid = 'AS400DOC-000000016734036'
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
midrange.com
