This article provides an example to display invoice items of invoice id I010.
Select itemname from invitem,item where invitem.itemno=item.itemno and invno='I010'; Output: ITEMNAME --------- CPU