Compare id in 2 tables

Hello,

I want to compare two tables (quite heavy) according to an id.
Source table and target table.

On the source table I have fields including an ID field that is unique, I load this ID value into an Easymorph table (source).
"select id as id_s from source_table".

Then in my target table I also have this field, which I load into another Easymorph table (traget).
"select id as id_t from target_table"

I've created a table derived from the source table and I'd like to retrieve the IDs from the target table that no longer exist in the source table?

Thanks for your help

https://help.easymorph.com/doku.php?id=transformations:keepremovematching

1 Like