Prev < SQL Editor with code completion             Next > Easier handling of large tables

Database relations

Add foreign key table columns and you'll automatically see joined data without any manual SQL. For example, if you have EmployeeID field that points to Employee table, you can include other data like Name or Title from that related table.

Pick up all columns from foreign table that should be visible:

Use lookup values from foreign table instead of manually entering IDs:

Display parent and child tables simultaneously, and you'll immediatelly see all related rows as you browse main table:

Prev < SQL Editor with code completion             Next > Easier handling of large tables