Page Title

You should see a table of the join of event and location

Since event is the many side of the join an inner join is fine.
If we wanted all locations, even those without events, then we'd use an outer join
Notice in the query we had to alias event.name and location.name. Otherwise the recursive row creation would write the former over the latter
We also use ORDER BY, to sort by date

Go BACK to first page.

Id	Date	Type	EventName	LocationName	Street	City	Region
1	2020-07-15	PRIVATE_EVENT	Retirement Party	Knights of Nee Hall	918 Collinson St 510	Victoria	BC
2	2020-07-17	MUSIC_TICKET	Heartbreak Gentlemen Disco	Slow Arrow Brewhouse	6912 Lefroy Crt SW	Calgary	AB
3	2020-07-18	MUSIC_FREE	Furries Of Pickled	Shipyard Pub	3308 Ash St	Vancouver	BC
4	2020-07-20	COMEDY_SHOW	5 Comedian Line-up	Hoppy Barman Garage	272 Huntington Close NE	Calgary	AB
5	2020-08-02	COMEDY_SHOW	Open Mic Night	Hoppy Barman Garage	272 Huntington Close NE	Calgary	AB
6	2020-08-02	MUSIC_FREE	Kurt Eats the Guitar	The French Quarter	2485 Broadway W 414	Vancouver	BC
7	2020-08-13	MUSIC_FREE	Blues night	The French Quarter	2485 Broadway W 414	Vancouver	BC
8	2020-08-15	MUSIC_FREE	Rubbish London Dog	Dizzy Crown Eatery	13352 Old Yale Rd 620	Surrey	BC
9	2020-08-16	PRIVATE_EVENT	Betterment of Humanity Fundraiser	South Burnaby Community Hall	5202 Union St	Burnaby	BC
10	2020-08-21	MUSIC_TICKET	Maniacal Reflection with Guests	The Place	6056 Stanton Dr SW	Edmonton	AB
11	2020-08-23	COMEDY_SHOW	The Pat Jones Experience	Cheerful Rhino	121 Wildwood CPk	Winnipeg	MB
12	2020-08-24	PRIVATE_EVENT	Eastvale High Reunion	South Burnaby Community Hall	5202 Union St	Burnaby	BC
13	2020-08-27	MUSIC_TICKET	The Motivated 8	Hoppy Barman Garage	272 Huntington Close NE	Calgary	AB
14	2020-08-30	MUSIC_TICKET	Pillbox Minute with Melvins Mission	Slow Arrow Brewhouse	6912 Lefroy Crt SW	Calgary	AB
15	2020-08-31	MUSIC_TICKET	Twilight of the Guitar Gods	The Place	6056 Stanton Dr SW	Edmonton	AB
16	2020-09-03	MUSIC_TICKET	Chained Millimeter And The Menageries	Bar Five	2130 Jordan Dr	Burnaby	BC
17	2020-09-03	MUSIC_TICKET	Red Of The Shirtless	Bar Five	2130 Jordan Dr	Burnaby	BC
18	2020-09-08	PRIVATE_EVENT	Jones/Smith Wedding	The French Quarter	2485 Broadway W 414	Vancouver	BC
19	2020-09-13	MUSIC_TICKET	The Society of the Beloved Hive	Bar Five	2130 Jordan Dr	Burnaby	BC
20	2020-09-14	PRIVATE_EVENT	Goldberg bat mitzvah	South Burnaby Community Hall	5202 Union St	Burnaby	BC

Test Join Table