Join Condition between tables

Former Member — Wed, 23 May 2007 13:50:37 GMT

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

Re: Join Condition between tables

Former Member — Wed, 23 May 2007 14:51:52 GMT

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...