Assuming you want set AA.COMM equal to bb.CATE, the SQL Update statment would look something like this:
UPDATE aa SET aa.COMM = (SELECT bb.CATE FROM bb WHERE aa.TOY#=bb.TOY# and aa.PART#=bb.PART# and bb.CATE='60')
================================== MORE INFORMATION ON THIS TOPIC ==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
This was first published in April 2003