/*This SQL script uses Demo database.
  This sample illustrates use of INNER JOIN statment.
  The query shows events and venues where it will occur.
  Notice that if VenueNo corresponding to event is not 
  found in "venues" table, it will not be shown.*/

select VenueNo, Event_Name, Venue, Event_Date
from Events e
inner join Venues v
ON (e.VenueNo=v.VenueNo)
order by Event_Name
