>_ IzzyLab

Topic breakdown

Relational data is usually spread across several tables linked by a shared field (a foreign key). The JOIN operator combines rows from two tables, and the condition after ON specifies which field of one table must match a field of the other. In SELECT you list the right columns from both tables; aliases shorten the notation but aren't required. The sqlite3 utility takes a database file and a SQL string, and the output is redirected to a file with >.

What's checked

  1. one name|amount line per order in the report

What it looks like