Banner

 

5 - The Many-to-Many Relationship
Slide Exercises

A keen field hockey fan wants to keep track of which countries won which medals in the various summer Olympics for both the menís and womenís events


Report all brown items that have been sold.
SELECT itemname, itemcolor FROM item 	
  WHERE itemcolor = 'Brown' 		
  AND EXISTS (SELECT * FROM lineitem 		
  WHERE lineitem.itemno = item.itemno); 

Report all brown items that have not been sold
SELECT itemname, itemcolor FROM item 	
  WHERE itemcolor = 'Brown' 		
  AND NOT EXISTS (SELECT * FROM lineitem 		
  WHERE lineitem.itemno = item.itemno); 

This page is part of the promotional and support material for Data Management (sixth edition) by Richard T. Watson
For questions and comments please contact the author

Date revised: 19-Oct-2016