Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple where clause on same column

user10826019Aug 11 2016 — edited Aug 11 2016

Hi All,

I have a data in the format below.I have 2 tables as shown below

  Table 1

Deal ID
1
2
3
4
5
6

Table 2

 

Deal IDWeb Order ID
1NULL
1NULL
1648545454
1648545464
2684343434
2684343434
2684343434
2684343434

I want output result as

Output:

Deal ID

1

Thanks

Hibin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2016
Added on Aug 11 2016
13 comments
355 views