IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Help on SQL statement.


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Mar 28, 2013 12:32 pm
Reply with quote

I have table TA, which is like this:
Code:

ATTR   VALUE
-------  -------
0001   COLA
0001   COLB



I have another table TB, which is like this:
Code:

COLA   COLB
-------  -------
AAAA   BBBB


that is, the column name of TB is the value of a column of TA.

I want to get below result, how to compose the sql statement?
Code:

0001AAAABBBB
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Mar 28, 2013 6:51 pm
Reply with quote

Hello,

As usual you have not provided much to work with . . .

How many rows are in TA? TB? How many should be selected and why?

How did this particular "requirement" arise? Explain in terms of actual data and no, it is not proprietary to use fake data rather than real data.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Mar 29, 2013 6:05 pm
Reply with quote

I don't have specific bussiness requirement.
I just want to konw if it's feasible for DB2.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts JOIN STATEMENT PERFORMANCE. DFSORT/ICETOOL 12
No new posts Relate COBOL statements to EGL statement All Other Mainframe Topics 0
No new posts process statement for SUPREC, CMPCOLM... TSO/ISPF 4
No new posts SYNCSORT/ICETOOL JOINKEYS SORT Statem... DFSORT/ICETOOL 13
No new posts DFDSS COPY using Filter REFDT statement JCL & VSAM 2
Search our Forums:

Back to Top