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
 

 

Need Help - Join Query

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

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Tue May 01, 2012 1:24 am    Post subject: Need Help - Join Query
Reply with quote

Team ,
Can you please help me to provide query for below one?
consider 2 table (Master and Child)

Master - 4 Column(Coupon id ,Coupon nbr,Type and code)

Table 1 - Master
Coupon id Coupon nbr Type Code
1 1 A A
2 5 B B
3 8 C D
4 1 A A


Child -3 Column(Coupon nbr,Type and code)

Table2 - Child

Coupon nbr Type Code
1 A A
1 A D
5 B D
5 B C
8 C D



I need all the rows of Coupon Id (master )where Coupon number(Column BA -Master and Column A -Child) should match both tables but either Type(Column C -Master and Column BA - Child) or Code (column DA - Master and Columns C - Child)
should not match in both tables

Below output shows that for Coupon id 2 , Coupon nebr matches but Code column of Master doesn't match with child
for Coupon id 4 ,Type column of Master doesn't match with child


Output

Coupon Id

2
4

Thanks
Jagadesh
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue May 01, 2012 1:59 am    Post subject:
Reply with quote

no logic in the world is going to disqualify coupon_id = 1
yet select coupon_id = 4
(other than id = 1 id=4).

also, i feel great disrespect from you
for posting such a question without proofing your expected output.

db2 column names do not contain spaces,
and an underscore is nothing but an upper-case hyphen,
so get used to using the key.

learn to use BBcode to enclose text containing formatted text.
your examples and explanation are hard to follow,
and then we have to figure out what you want with that bullshit that you provide as expected results.

either do a left outter join (master/child) selecting those with null for child
or
do a not exist in

and we are not your team!
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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


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