|
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
Download Absolute Database | Learn more |
|
|
Current version: 7.96
Released: May 27, 2025
Price: $ 149
 
|
|
|
Thanks again for the superb tech support, I was worried I'd hit a brick wall this close to the finish line. Even working on the weekend... you guys rock!!!
Bob Boyd
|
|
|
