Full outer join

[jparman]

i want to create a list report in servicenow

Table 1: cmdb_sam_sw_install

Filter: Display name = Adobe Systems Creative Cloud

Columns to display in report:

1. Display name

2. Assigned to

3. Last Used

Table 2: samp_sw_subscription

Filter: Display name = Adobe Systems Creative Cloud

Columns to display in report:

1. Display name

2. User

3. Last Activity

I want to join this table on User = Assigned to. But I also want to show if the User is in samp_sw_subscription and Assigned to is not in cmdb_sam_sw_install.

I want this data in just 1 list report

[palanikumar]

You can use Left Join to achieve this. Refer this URL for sample

https://www.servicenow.com/docs/bundle/zurich-platform-administration/page/use/reporting/task/exampl...

[jparman]

But still this does not result to a full outer join. It will not include records from table 2 that are not present in table 1.

[palanikumar]

I think you don't need join. 

You can tweak the condition as below

(User = Assigned to) || (User = samp_sw_subscription && Assigned to != cmdb_sam_sw_install)