Query design

Table(s)
Field(s)
Search criteria
Sort order

Changing the design rewrites the SQL and runs it.

SQL

Output

The database

row used by the selected output rowadded or changeddeleted

Primary keys are underlined. Foreign keys are marked *.

Real SQLite running in this browser. N5 SQL: SELECT, FROM, WHERE (AND, OR, =, <, >, <=, >=), ORDER BY, the equi-join, INSERT, UPDATE and DELETE.