PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1

Back Next

Joining Sources Using Exec SQL

Exec SQL joins tables much like standard SQL. Exec SQL selects all tables with one SELECT statement. The Designer generates the WHERE clause for the join condition after the SELECT statement. When you join tables using exec SQL, the ABAP program performs an inner join.

The following sample exec SQL is generated to join the same transparent tables (KOHN, KOHM, and KONP) as above:

exec sql [...]
  SELECT KONH.MANDT, [...], KONM.KOPOS, [...], KONP.MANDT, [...]
  INTO [...]
    FROM 
  KONP, KONH, KONM
  where 
  KONP.MANDT = :client_var and 
  KONH.MANDT = :client_var and 
  KONH.MANDT = KONP.MANDT and 
  KONM.MANDT = :client_var and 
  KONM.KNUMH = KONP.KNUMH
endexec.

Rename Saved Search

Table of Contents

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Joining Sources Using Exec SQL

Joining Sources Using Exec SQL