Enrichment with Table with non existent data

Hello All,

I am getting a list of Recipients from the query in the workflow activity.

What I need to do is take the ISO value of the Recipient Location and Query another external table to fetch some data basis the Location.

i.e if Recipient Location ISOValue = External Table ISOValue, then fetch another column from external table

Here the issue is Recipient Location might have few values, which need not be present in the external table. In those case I need the column value to be blank or null ( Like an external Join )

When I use enrichment, -> Additional Data and Simple Join, it doesn't list those records not present in External Table, ( behaves like a inner join )

What should be the best method to fetch both existent and non existent data ( blank/null) from the external table

Regards,

DG