View previous topic :: View next topic
|
Author |
Message |
itjagadesh
New User
Joined: 05 Dec 2006 Posts: 89 Location: chennai
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
|