>_ IzzyLab

Topic breakdown

JOIN combines rows from two tables by a matching condition specified in ON. Here one table references another via a foreign key: the child row stores the numeric id of the parent, not its human-readable fields, so the right name lives in the related table. A regular (INNER) join keeps only rows that found a match on both sides; if records without a match were needed too, a LEFT JOIN would be required. Table aliases shorten the notation and resolve the ambiguity of identical column names.

What's checked

  1. join sorted by amount

What it looks like