Edit join paths in Visual SQL

A join path is the visual representation of a JOIN clause in a visual mode query. A JOIN clause brings together the rows from two or more tables into a single set of data by connecting the tables using foreign key relationships defined in the schema. Using the correct join path is essential for ensuring you’re querying the correct data.

To edit the join path in visual mode:

1. [Join path (結合パス)] を選択します。ポップアップが表示されます。

2. 代替結合の列名または行を選択します。線が青くなり、現在選択されていることを示します。

3. 更新した結合パスでクエリを実行するには、[Run query (クエリを実行)] を選択します。

Read more about editing join paths in visual mode queries.

例

The Work item table contains three foreign keys that connect to the “Account” table:

• 担当者アカウント ID

• 作成者アカウント ID

• 報告者アカウント ID

If you wanted to get the name of the assignee for each work item in a single query, you’d need to make sure that the join path uses the Assignee account ID column to connect the Work item table to the Account table. Otherwise, you may end up getting names of creators or reporters instead.