Previous Next

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.

Return to the list of articles »