Problem
Writing a multi-table join means knowing the foreign keys by heart. The schema already holds them and the ER diagram already draws them, but neither can produce the query.
Proposed solution
- Pick tables, and the builder proposes join conditions from the foreign keys between them.
- Choose columns per table, add conditions, and see the generated SQL update as you go.
- Open the result in a normal query tab, editable as text from then on. This generates a starting query, it does not replace writing SQL.
- Reachable from the ER diagram by selecting two related tables.
Alternatives considered
Read the structure tab and write the join by hand.
Related database type
N/A / General
Problem
Writing a multi-table join means knowing the foreign keys by heart. The schema already holds them and the ER diagram already draws them, but neither can produce the query.
Proposed solution
Alternatives considered
Read the structure tab and write the join by hand.
Related database type
N/A / General