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.

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.

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.

Company

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.