Category: SSC

Journal: SQL Saturday #52

Friday 6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip. 9:30am local time, we arrive in CO. Grab a car and head north to Fort Collins for Beau Jo’s pizza, free loaner bikes from the Bicycle Library, and general sightseeing. BEAUTIFUL flower garden on the university […]

Breaking Into SQL Showbiz

Matthew Velic (blog, Twitter) just asked this question on Twitter: And really that’s a question I’d ask anyone on the “speaker’s circuit” – where’s the easy place to break in? Wow, Matt…in the words of the great Ricky Ricardo, lemme splain something to joo..  A year ago today, I was just a few months into […]

SELECT: If ON preceeds JOIN, then how….

I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night.  There were a few questions pointing to the same area:  * How is the ON clause evaluated before the JOIN clause?  * If ON is evaluated before the JOIN, how does it resolve table aliases […]