Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of outer join to display items which are sold and not sold till today

Posted By: Ballard Schmidt     Category: Oracle     Views: 1485

This article provides an example of outer join to display items which are sold and not sold till today.

Code for Example of outer join to display items which are sold and not sold till today in Oracle

Select invitem.itemno "Order", item.itemno "Not Ordered" from invitem, item where invitem.itemno (+)= item.itemno;

Output:

OrderNot Ordered
------  -----------

I0001         I0001
I0002         I0002
I0003         I0003
I0004         I0004
I0005         I0005
  
Share: 

 
 
 


Ballard Schmidt
Ballard Schmidt author of Example of outer join to display items which are sold and not sold till today is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!