Join Condition between tables

[Former Member]

Hi all,

Is it possible to propose a join condition (using SQ02) between two fields of two tables other than what is proposed by the system?

Thanks

Sandeep

[Former Member]

Hi Sandeep,

You can very much match other fields of two tables in SQ02.

1. Goto SQ02

2. Give the infoset name

3. Goto change mode

4. Press the Join button, it will display the join conditions between the two tables.

5. Press Join Conditions, it will propose the system generated join conditions

with key fields

6. If you want to match your own fields other than the key fields you can just

point the mouse pointer on the field of the first table and just drag it to the field

of the second table. It will create a join condition.

7. Save the infoset.

Regards,

Jayaram...