SQL Complete - Suggesting Conditions for JOIN Statements
Contents
Introduction
Read this article to learn about suggesting conditions for JOIN statements.
For JOIN clauses, dbForge SQL Complete can suggest a full JOIN clause that
is based on foreign keys, or it can suggest conditions that are based on column
names. This suggestion is available after the JOIN keyword as well as after
the ON one.
Suggestions of full joining conditions after JOIN clauses
After entering the JOIN clause, dbForge SQL Complete offers tables
and connecting conditions for joining. Note that it offers the tables with
the foreign keys referencing the current table and the tables referenced by foreign
keys of the current table.
Furthermore, it's not important in which order the table names are typed, as the
tool will offer you the right options in any case.
The following example shows the options offered by dbForge SQL Complete after the
JOIN clause:
Suggestions After JOIN Clause
In the example, dbForge SQL Complete offers tables and eight options for joining
the current table with related ones using the foreign key column BusinessEntityID.
Suggestions of joining conditions after ON clause
After entering the ON clause, the tool offers to select one of the joining
conditions from the list. The joining conditions include conditions based
on foreign keys and column names matching.
In case the joining condition based on foreign keys matches with the condition based
on column names, dbForge SQL Complete offers you just one of them excluding the
duplication.
The following example shows the options offered by dbForge SQL Complete after the
ON clause:
Suggestions After ON Clause
In the example, the first suggesting condition in the list is based on the
foreign key matching and the other two conditions are based on the column
names matching.
Conclusion
Context-based prompt functionality for JOIN clause offers all possible combinations
to join tables. You don't need to type expressions for joining tables as well as
for searching tables that you want to join.
The feature will save your time on typing queries using the JOIN clause. It will
be enough just to select the appropriate table or joining condition
from the list.
Our product is also stuffed with lots of other features that will speed up typing
T-SQL queries and bring more comfort as well as productivity to your work.
Take Trial
Return to the list of articles »