Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 joins

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
srikanthkailasam

New User


Joined: 13 Nov 2006
Posts: 24
Location: Bengalooru

PostPosted: Wed Oct 28, 2009 6:19 am    Post subject: DB2 joins
Reply with quote

Hi,

I have table A and Table B

I need fields a1, a2, a3 from Table A and fields b1, b2 ,b3, b4 from Table B.
where a1=b1=X and a2=b2=Y and b4=a3.

How can I achieve this?

Thanks in advance for the help
Back to top
View user's profile Send private message

srikanthkailasam

New User


Joined: 13 Nov 2006
Posts: 24
Location: Bengalooru

PostPosted: Wed Oct 28, 2009 6:42 am    Post subject: Reply to: DB2 joins
Reply with quote

Got the solution...
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Wed Oct 28, 2009 7:15 pm    Post subject: Reply to: DB2 joins
Reply with quote

Hello,

It helps no one to post a question and then post there is a solution and not post the solution. . . icon_confused.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help in Joins rajendra kalepu JCL & VSAM 9 Wed Oct 30, 2013 10:11 pm
No new posts Sort Joins umanaga DFSORT/ICETOOL 7 Fri May 25, 2012 4:56 pm
No new posts joins four types..can we use all in DB2 kumar119119 DB2 2 Mon Jun 28, 2010 11:18 pm
This topic is locked: you cannot edit posts or make replies. Difference between Corrrelated Subque... Sudeshna Sarkar DB2 2 Sat May 15, 2010 3:18 pm
No new posts For Update Of in Cursor with Joins RAJA-RAJA DB2 1 Mon Apr 12, 2010 6:05 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us