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

DB2 joins


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
Reply with quote

Got the solution...
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: Wed Oct 28, 2009 7:15 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need help in Joins JCL & VSAM 9
No new posts Sort Joins DFSORT/ICETOOL 7
No new posts joins four types..can we use all in DB2 DB2 2
This topic is locked: you cannot edit posts or make replies. Difference between Corrrelated Subque... DB2 2
No new posts For Update Of in Cursor with Joins DB2 1
Search our Forums:

Back to Top