inner_join.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 11 行

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  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 e1."Event_Name", v2."Venue"
  from "events" e1 
 inner join "venues" v2
    on (e1."VenueNo" = v2."VenueNo")
 order by e1."Event_Name" asc