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
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
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_idTo edit or define the join, click the ellipses (…) to the right of the property to bring up the Join dialog box.