This is a heavily interactive web application, and JavaScript is required. Simple HTML interfaces are possible, but that is not what this is.
Post
SQLDaily
sqldaily.bsky.social
did:plc:blmnab373idbogizdn742doc
Take care when filtering the INNER table in OUTER JOINs
e.g. the right table in a LEFT OUTER JOIN
Do this in the WHERE clause => it's an INNER JOIN
To preserve the OUTER JOIN, filter the inner table in the ON clause
The pic shows outer joins ON number col with inner filters
2025-09-15T11:02:17.301Z