Q

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

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close