Procedure documentation Linking Table Columns with JOINS Locate the document in its SAP Library structure

Use

You can use the Visual Query dialog to link table columns with JOINS* in database queries.

Prerequisites

When you created the Visual Query, you copied the tables containing the columns you want to link together to the area for selecting tables.

Procedure

  1. In the table selection, select the table column that you want to link, and choose the Drag&Drop function to link it to the relevant column in the other table. The system displays a connecting line between the two table columns.
  2. To specify the JOIN in more detail, select it, and choose Show Join Definition in the context menu. The system opens a window for the JOIN definition. Select the JOIN type and relational operator, and choose OK.
  3. To delete a JOIN, select it and choose Delete Join in the context menu.

Note

If you copy the same table to the table selection twice, SQL Studio assigns an alias name. In this way, you can create SELF JOINS.

For information on the syntax of JOINS, see the Structure linkJOIN predicate section of the Reference Manual: SAP DB.