Writing an SQL statement when two files have the same name

There are two physical files named aa and bb. Both have the same fields: TOY# & PART#. Besides these, to file aa, there is a field COMM. And to file bb, there is a field CATE. Now I'd like to update aa.COMM when aa.TOY#=bb.TOY# and aa.PART#=bb.PART# and bb.CATE='60'. Would you please tell how to write the SQL statement?

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

Back to top