Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display invoices containing item keyboard in list

Posted By: Lilly Hughes     Category: Oracle     Views: 1555

This article provides an example to display invoices containing item keyboard in list.

Code for Display invoices containing item keyboard in list in Oracle

Select invno, itemname from item, invitem where item.itemno=invitem.itemno and itemname='Keyboard';

Output:

INVNO    ITEMNAME
-----    ---------

IN003    Keyboard
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display invoices containing item keyboard in list Or get search suggestion and latest updates.

Lilly Hughes
Lilly Hughes author of Display invoices containing item keyboard in list is from London, United Kingdom.
 
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!