Share via


Join Properties

This window opens when a join (a connecting line between two tables) is selected in the Diagram pane of Query and View Designer.

Note

The properties in this topic are ordered by category rather than alphabet.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

  • Identity Category
    Expands to show the Name property.

  • Name
    Shows the name of the selected join, which is composed of the names of the two columns involved in the join.

  • Query or View Designer Category
    Expands to show the Join Condition And Type property.

  • Join Condition And Type
    Provides a text description of the join type and condition, in the format JOIN type: condition. For example, an inner join on the title_id fields of the dbo.titleauthor and dbo.titles tables would appear as:

    INNER JOIN: dbotitleauthor.title_id = dbo.title.title_id
    

    To edit or define the join, click the ellipses (…) to the right of the property to bring up the Join dialog box.

See Also

Other Resources

Properties in Visual Database Tools

Querying with Joins