Blog

Notes on practical software engineering and AI systems.

Short posts on building useful software, applying AI responsibly, and keeping production systems maintainable.

SQL JOINs: The Practical Guide

JOINs combine data from multiple tables using related columns. A practical walkthrough of INNER, LEFT, RIGHT, FULL OUTER, CROSS, SELF, anti, semi, and non-equi joins with example data.