select_union.sql

AbsDataBase5.16 最新版

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of UNION keyword.
  In this query results of two "select" statements are combined in single dataset.*/


select Event_Name from events
where VenueNo<3
union
select Event_Name from events
where VenueNo>8