Skip to content

create-self-joins-automatically-visual-database-tools.md

Latest commit

 

History

History
34 lines (27 loc) · 1.44 KB

create-self-joins-automatically-visual-database-tools.md

File metadata and controls

34 lines (27 loc) · 1.44 KB
title Create Self-Joins Automatically
ms.custom seo-lt-2019
ms.date 01/19/2017
ms.prod sql
ms.prod_service sql-tools
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
automatic joins
self-joins
joins [SQL Server], self
ms.assetid f9ec90e8-3aad-415c-a5c4-8dfa9540e37f
author markingmyname
ms.author maghan
ms.manager jroth
ms.reviewer

Create Self-Joins Automatically (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] If a table has a reflexive relationship in the database, you can join it to itself automatically.

To create a self-join automatically

  1. Add to the Diagram pane the table you want to work with.

  2. Add the same table again, so that the Diagram pane shows the same table twice within the Diagram pane.

    The Query and View Designer assigns an alias to the second instance by adding a sequential number to the table name. In addition, the Query and View Designer creates a join line between the two rectangles representing the two different ways the table participates in the query.

See Also

Query with Joins (Visual Database Tools)