cancel
Showing results for 
Search instead for 
Did you mean: 

Joining 2 tables

Former Member
0 Kudos

Hi Experts,

I am using 2 tables "PROBSUMMARYM1" and "SYSATTACHMEM1" in my report.

Link is between these two fields {PROBSUMMARYM1.NUMBER}--->{SYSATTACHMEM1.TOPIC}

Table "PROBSUMMARYM1" is having 100 records and table "SYSATTACHMEM1" is having only 20 records that is also present in "PROBSUMMARYM1". In my report am getting only 20 records that are present in table "SYSATTACHMEM1".

What i should i do to get the record that are not present in table "SYSATTACHMEM1".

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member205840
Active Contributor
0 Kudos

Hi Ajay,

Also go in Link tab-- double lick on join and go in LInk Type and select != (not equal to).

-Sastry

abhilash_kumar
Active Contributor
0 Kudos

Hi Ajay,

Go to the Database Expert > Click the Link arrow > Change the Join type to 'Left Outer'.

Then, go to Report > Selection Formulas > Record and use this code:

{SYSATTACHMEM1} = 0 OR IsNull({SYSATTACHMEM1})

-Abhilash