On: INNER JOIN ON vs WHERE clause (2009)

[wild_egg]

I haven't used mssql since ~2013 but I think you're right that it's not available there.

Works great in MySQL, PostgreSQL, and SQLite though.