SQL · Advanced

SQL JOINs

Stitch two tables together on a key — switch the join type and watch the matches and the NULLs change.

join type

users4 rows

idname

orders5 rows

iduser_iditem

users LEFT JOIN orders5 rows

u.idnameo.iduser_iditem

query.sql