When you add two or more tables to a query, dbForge Studio automatically creates joins based on existing relationships or matching columns.
dbForge Studio automatically adds join lines between tables in the following cases:
Each table includes a column with the same name and data type, and at least one of the columns is a primary key.
Example: If you add the person and password tables, and password_id is a primary key in the password table, dbForge Studio creates a join if both tables include a password_id column with the same data type.
A search condition implies a join, such as a WHERE clause that compares the same column in both tables.
Example: If you add the person and password tables and use a condition that compares password_id in both, dbForge Studio recognizes it as a JOIN condition and creates the JOIN automatically.
If the automatically created JOIN doesn’t meet your needs, you can edit or delete it. If no JOIN is created, you can add one manually.
Note
dbForge Studio creates only one automatic JOIN per pair of matching columns. If multiple matches are found, the tool uses the first matching pair it detects.