select_different_db.sql

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

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This example illustrates get data from TWO DATABASES IN SAME QUERY. 
  The query lists all events, event prices and venues where they take place. Note that you can specify two different databases.*/

select Event_Name, Venue, Ticket_Price
from "C:\Program Files\AbsoluteDatabase\Demos\Data\Demos.abs".Events e, 
     "C:\Program Files\AbsoluteDatabase\Demos\Data\Demos.abs".Venues v
where e.VenueNo = v.VenueNo