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: 1924

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!